COUNTIF FORMULA FOR CHILDREN ROW WITH CRITERIA

Options

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


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!