dashboard formula to show completions in last 30 days

JessMc3

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.

Darren Mullen

@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.

Darren Mullen

@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.

JessMc3

@Darren Mullen Thank you so much! Making the report was exactly the step I needed!!

Darren Mullen

@JessMc3 You're welcome!