Row numbers to a dashboard

bjones86121
bjones86121 ✭✭
edited 12/09/19 in Smartsheet Basics

We monitor the number of requests that come into 3 different Smartsheet forms week over week... i created a dashboard to show the requests within the past 7 days, but i need the rows to tally... even if the row number shows up on the dashboard itself, that works - i can simply see that 45 rows were created in the last week. Is this possible?

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 04/19/19

    Hi,

    Yes, it is!

    You'd have to sum it on the sheet or another sheet with cross-sheet formulas, and then you could use the Metric Widget to show that number on the Dashboard.

    Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

    Would that work?

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.