dashboard formula to show completions in last 30 days

Options

Good afternoon,

I am still a bit new to smartsheets.

Would someone be able to assist me with creating a formula that shows how many requests have been submitted within the past 30 days? The goal is to use this on a dashboard so that any date you go on it will show the correct data for past 30 days of submissions. I am assuming I should use a countifs function. I need to note the request submitted for 2 different types of access on our sheet - and want the count to be over the past 30 days.

Thank you in advance for your help.

Best Answer

  • Darren Mullen
    Darren Mullen ✭✭✭✭✭✭
    Answer ✓
    Options

    @JessMc3 You can approach this a number of ways that I can think of quickly.

    1. You can use a report with a filter that only shows rows in the last 30 days, and then use the summarize function to get a number that you could display on the dashboard. I forget if you can display the summarized number from a report as a metric number, or only as a chart.
    2. Create a sheet summary field on your sheet and use the countif or countifs function to compare if the date in question is greater than today() - 30 (or greater than equal to depending on if you want to include that first date calculated by today() - 30). This for sure you can display as a numerical widget on your dashboard.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!