Why won't my Nested COUNTIFS work?

Jon's Smartsheet · 01/23/19

Hoping the community can assist!

These two COUNTIFS work separately.

=COUNTIFS({Finish}, >TODAY())

=COUNTIFS({PctComplete}, <1)

But why isn't it working when I nest them together? (it returns #Incorrect Argument Set?)

=COUNTIFS({Finish}, >TODAY({PctComplete}, <1))

If you care to, I'd appreciate answers to a few additional questions:

I'm also confused with why the first forumla above requires the empty parens, but the 2nd formula is working without them.
Smartsheet documentation shows square brackets [], but the actual software is inserting squigly brackets {}. Is there a difference?

Thanks,

Jon

Nic Larsen · 01/23/19

Try this:

=COUNTIFS(Finish:Finish, >TODAY(), PctComplete:PctComplete, <1)

Mike Wilday · 01/23/19

You were missing the comma after the Today(). It wasn't separating out your statements as separate conditions.

Andrée Starå · 01/23/19

Hi Jon,

To add to previous answers.

Smartsheet documentation shows square brackets [], but the actual software is inserting squigly brackets {}. Is there a difference?

Square brackets are used when there are numbers or more than one word in the column name.

The curly braces are used when you want to use cross-sheet formulas.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Formulas and Functions