'Parse rows by date filter (Google Tables)
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.
Solution 1:[1]
See if this helps
=filter(A2:C; C2:C-today() <=3)
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | JPV |
