COUNTIFS OR Formulas

Options
A Rose
A Rose ✭✭✭✭✭
edited 12/10/21 in Formulas and Functions

Hi,

I want to count if range 1 contains value, or if it is any time in the future,

Range 1 is a restricted Date Column.

It should be something like this:

=COUNTIFS({Range 1}, "", >TODAY(), {Range 1}

What is the correct formula?

Thank you!

Best Answer

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

    Hi @A Rose

    You're close! In a COUNTIFS you first list the range, then you list the criteria. If you want to count the number of cells that are in the future, try this:

    =COUNTIFS({Range 1}, >TODAY())

    If you want to count two separate values, such as if it's blank OR if it's in the future, then you're right, you can use OR, like so:

    =COUNTIFS({Range 1}, OR(@cell >TODAY(), @cell = ""))

    Let me know if this works for you!

    Cheers,

    Genevieve

Answers

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

    Hi @A Rose

    You're close! In a COUNTIFS you first list the range, then you list the criteria. If you want to count the number of cells that are in the future, try this:

    =COUNTIFS({Range 1}, >TODAY())

    If you want to count two separate values, such as if it's blank OR if it's in the future, then you're right, you can use OR, like so:

    =COUNTIFS({Range 1}, OR(@cell >TODAY(), @cell = ""))

    Let me know if this works for you!

    Cheers,

    Genevieve

  • A Rose
    A Rose ✭✭✭✭✭
    edited 12/14/21
    Options

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!