=COUNTIFS({Belleville - 1N Front St (task) Status}, [Not Started]@row, {Belleville - 1N Front St (task) Status}, "Children"

I am trying to create a formula for my in progress tasks. My countifs keeps changing to not started and the formula is giving me an error. My total In Progress is calculating wrong bc it is including my ancestors.

Please help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!