Filtering task table by due date = today + 1

Hi! I’ve seen some similar questions to mine but I haven’t been able to find a formula that works.

I’m using the GTD To-Do List. I appreciate having filtered tables of tasks for tomorrow, the next 7 days, and beyond. However, I can’t figure out having a separate filtered table with tomorrow as the due date.

Here’s what I have currently: thisRow.Done = false AND thisRow.When=(Today() + Days(1))

Can anyone help me understand what I’m doing wrong? Thanks!

Hi @Sarah_duRivage-Jacobs and welcome to the Coda Community!

Try this formula: thisRow.[Due Date] = Today() + 1

I just created a demo for you real quick. Please check it out and let me know if that is what you wanted to accomplish.

Here is the link to the doc:

Sincerely
Jannis

1 Like

Yes, this is it! Thank you!

Sarah duRivage-Jacobs
Writer and editor of words dealing with reproductive health.

p: 917-318-1683 e: s.durivagejacobs@gmail.com
w: www.sarahdurivagejacobs.com

1 Like

Okay, great.

Have a nice day!

Sincerely
Jannis :raising_hand_man:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.