How to count children cells from % complete column - countif not working

Options

This is for my % complete column. I'm trying to count the children tasks if the % Complete is less than 100%.

I'm using this formula: =COUNTIF(CHILDREN([% Complete]):([% Complete]), <100%) but it is not returning a count, just displays the formula as it isn't correct syntax but can't figure it out.

Thanks in advance!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!