I am creating task reports for our team that pulls tasks from multiple sheets and aggregates them into one, easy to read report. I'm using reports because I want to apply date filters and structure task reports to show all outstanding tasks (past due and due today) and upcoming tasks (tasks due within the next week).
I thought I created a report to do this, but the date filter turned out to be static and need to be updated daily in order to function properly. Am I doing something wrong is there not a way to set the date filter to change dynamically?