Counting Occurrences within 6 months

SOmalley1124

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!

Genevieve P.

Hi @SOmalley1124

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

Genevieve P.

Hi @SOmalley1124

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