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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!