Update Advanced Search - AND / OR Functionality



I would love to see the advanced search have the option to do AND or OR searches. Also to be able to search on sections or columns would be a much appreciated improvement!

Filterlogic in advanced search


I am trying to build a report that is showing tasks that have been completed within the last 7 days AND tasks that are due within the next 7 days and sort them by assignee. The goal is to see what has been done and what is coming up for my staff from different teams/project.

As far as I am aware there is no way to achieve this. Am i missing something?
Adding Filters for “completed within XX” AND “due in XX” only shows tasks that have been completed in the past but would be due in the future.



Hi @Markus_Hohlbein!

You could run the Search below, but it won’t automatically update, so you would have to update the dates manually every time you need this report!

Unfortunately as it stands, there is no option to have one condition (=completed) for the last 7 days and another condition (Incomplete) for the next 7 days.

My apologies that I can’t be of greater assistance, but I hope this helps to clear things up!