Displaying information on a dashboard based on today's date and the past 7 days


I have created a dashboard with a chart widget (columns). It is currently displaying all of the information from my report. My report is using Summary Sheet information. The end user only wants to see the information for the past 7 days, not all of the data. Is there a way for the dashboard to automatically update on a daily basis to only show the last 7 days worth of data?

Thank you in advance for any assistance.



  • BullandKhmer
    BullandKhmer ✭✭✭✭✭
    edited 11/09/21

    @Carol-Anne Cerbone,

    my suggestion would be to run a new/separate report filtered down to the last 7 days and run the widget off that new report. This will automatically update and should solve this issue.

    Hope that helps. Let me know if you need any more detail.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!