Filtering by Date

[Tziri_Lamm]

Hi! Brand new user here.

I created a tab called Due Soon and I have a column with a deadline.
I tried adding a filter but all the time related ones - within, on or before, on or after… only give options for today or now.

What am I doing wrong?

[david]

Currently you can only filter by comparing dates in each row to today or now. We will have to add more columns for ‘date math’ and allow you to do more complex comparisons before this is possible.

[Tziri_Lamm]

Thanks!
Is there any kind of workaround for me to create an upcoming deadline filter or tab?

[George_B]

Create a column to calculate the number of days till due then use that for the filter.

[Tziri_Lamm]

Perfect! Thank you!

[Carlos_Marchan]

Hi George. How can I set this complementary calc-date column to calculate automatically the nr of days each time a new row is added?

[Christophe_HK]

Either using ARRAYFORMULA in the gsheet, either using a Math column in the data editor, I think it works for date computations.

[George_B]

Here you go.

[Carlos_Marchan]

Thank you George! Awesome!