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

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    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

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    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

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!