dashboard formula to show completions in last 30 days

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.

Find more posts tagged with

Accepted answers

Darren Mullen

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

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

All comments

Darren Mullen

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

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.