How to get a tally of rows fitting relative date criteria (start date within last 30 days etc)?
Hi team,
I have a Smartsheet used to track defects reported for the product I manage, and I need to report on 3 metrics. 2 of these are based on relative dates (sheet includes Start Date and Date Closed columns) and my team hasn't been able to get the formulas parsing properly. I'd appreciate any help or advice!
- Total number of open issues (this formula works as intended): =COUNTIF(Status:Status, <>"Complete")
- New issues opened within last 30 days (UNPARSEABLE error): =COUNTIFS([Start Date] < TODAY(-30), [Status]<>"Complete")
- Issues closed within last 30 days: this should be a similar formula to item 2, but with Date Closed within the last 30 days, and Status equal to Complete.
Thank you in advance for your help!
Tags:
Answers
-
Hi @Laurel D you are so close with that formula! You are just missing a couple commas and ranges
=COUNTIFS([Start Date]:[Start Date], < TODAY(-30), Status:Status, <>"Complete")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!