OR in advanced search

I’m trying to create a report for my team’s last week of work. I can do that with advanced search and:

  • filter by team
  • filter by completed in the last 7 days

However, I would also like to include tasks that were due in the last week and didn’t get completed. To do that, I would need an “OR” condition:

  • completed in the last 7 days OR
  • due in the last 7 days

Is that possible? I can’t find a way to do that.

Welcome to the Forum @dzilli and thank you for reaching out.

As it stands, there isn’t an “OR” condition to combine these 2 filters. The closest solution that I can think of is to create a Report for tasks with due date within the last 7 days and once you get the report, you can sort them by “Completion Time” (Of course it won’t include task with due date not included in the last 7 days that were completed).

I hope this can help you in some way! Have a great Friday!

Thanks. As you say that misses out on tasks completed in the last week that don’t have a due date in the last week.
Another workaround is to have two different reports for completed and not completed.

1 Like

You are correct @dzilli. I agree that the best way to achieve this is by creating two different reports. :smiley:

Please upvote this task if you want better search functions…