Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Dynamic Dates

Linn Cook
Linn Cook
edited 12/09/19 in Archived 2016 Posts

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? 



  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    Hi Linn

    In reports you have the date choices of ... In the past, or Today  or in the next xxxxx? 

    So you should be able to get just what you need? 


    Let us know if not and we can review the issue together? 




  • Linn Cook

    Ah I see the problem. When I selected the date range, I used "Is less than" and then selected "Today" from the calendar. My bad. Thank you for clarifying that for me.

This discussion has been closed.