IF formula for Status of Child
Options
Comments
-
Hi,
Try an IF statement with a COUNTIF function like the following:
=IF(AND(COUNTIF(CHILDREN(), "Complete") > 0, COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN())), "Complete", "Incomplete Tasks")
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!