How to get Smartsheet to show the last 7 days of data without manually updating graph everyday?

Is there a way to get a smartsheet dashboard to show the last 7 days of data on a graph? I am trying to show percentage trends over the last week.

Tags:

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi @Devon Spencer ,

    Build your chart from a sheet or report that queries your source data for elements in the date range you want to depict. The sheet cells would collect, countifs, sumifs data from today(), today(-1), today(-2) ....today(-7).

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    If @Mark Cronk's answer does not help, screenshots would help us better answer your questions. Sensitive/confidential data should be removed, blocked, and/or replaced with mock data as needed.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!