# COUNTIFS OR Formulas

Options
✭✭✭✭✭
edited 12/10/21

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!

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

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

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

Amazing! Thank you @Genevieve P. !

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!