Why won't my Nested COUNTIFS work?

Jon's Smartsheet

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

Try this: 

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

Mike Wilday

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

Andrée Starå

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