Counting Occurrences within 6 months
Hello,
I have a Smartsheet grid listing all clinics that have already activated and will activate in the future with a "Go-Live" Date Column. Is there a formula that can show how many clinics will be going live in the next 6 months and how many went live in the past 6 months?
Thank you!
Best Answer
-
The easiest way to do this would be to COUNT how many rows in your sheet have a "Go-Live" date in the last 183 days, and how many are in the next 183 days.
=COUNTIFS([Go-Live]:[Go-Live], > TODAY(-183), [Go-Live]:[Go-Live], <= TODAY())
This is looking for dates that are greater than 183 days in the past, but less than or equal to today's date. You can do the same for future dates:
=COUNTIFS([Go-Live]:[Go-Live], > TODAY(), [Go-Live]:[Go-Live], <= TODAY(183))
Here's more information - TODAY Function
Another option would be to create a Report and use the date filter to find the rows you need, then use a Summary to find the numbers.
Cheers,
Genevieve
Answers
-
The easiest way to do this would be to COUNT how many rows in your sheet have a "Go-Live" date in the last 183 days, and how many are in the next 183 days.
=COUNTIFS([Go-Live]:[Go-Live], > TODAY(-183), [Go-Live]:[Go-Live], <= TODAY())
This is looking for dates that are greater than 183 days in the past, but less than or equal to today's date. You can do the same for future dates:
=COUNTIFS([Go-Live]:[Go-Live], > TODAY(), [Go-Live]:[Go-Live], <= TODAY(183))
Here's more information - TODAY Function
Another option would be to create a Report and use the date filter to find the rows you need, then use a Summary to find the numbers.
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!