How can I get rid of rows that are not applicable?

Deirdre Kaylor

I am creating a report with any upcoming tasks that are due within the next 14 days. However, when I do that, it pulls in my entire sheet, even rows that are in the future and not within the next 14 days. How can I get this to only show tasks that are due within the next 14 days?

Screenshot 2022-05-27 091056.png

Screenshot 2022-05-27 3.png

Screenshot 2022-05-27 2.png

Andrée Starå

Hi @Deirdre Kaylor

I hope you're well and safe!

It looks like it's showing everything because you have two parts with an OR between them.

Do you only want to show the Due tasks upcoming for 14 days or do you need any other Criteria?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!