How could I parse rows from my table by dates (logic for example: today is 3 more days until the delivery date) and place it into another sheet?
https://docs.google.com/spreadsheets/d/1TTbIX3qNKXyQAQiJ2EuRNDKWy1YEhLBPzsVw8mxMhKs
I need to run this script automatically (or manually) every day to update a list.
CodePudding user response:
See if this helps
=filter(A2:C; C2:C-today() <=3)