Counting Occurrences within 6 months

Options

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 Admin
    Answer ✓
    Options

    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

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!