dashboard formula to show completions in last 30 days
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.
Help Article Resources
Check out the Formula Handbook template!