COUNTIF FORMULA FOR CHILDREN ROW WITH CRITERIA

Hello,

I'm trying to set up a formula that counts the children rows in the "Percent completed" column, per parent row. This formula will be put into Column13. But I only want to count the ones that are less than 100% completed. I'm having issues with adding in that criteria. Any suggestions?

Thanks,

Shadany

image.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!