"At Risk" Status Formula

Options
Rachel R.
Rachel R. ✭✭
edited 08/15/22 in Formulas and Functions

I have the following formula for setting the parent status. I want the parent status to change to "At Risk" should even just 1 child have an "At Risk" status. I am having a hard time figuring out how to add this criteria to this formula:

=IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN(Tasks@row)), "Complete", IF(COUNTIF(CHILDREN(), "Not started") = COUNT(CHILDREN(Tasks@row)), "Not Started", IF(COUNTIF(CHILDREN(), <>"") > 0, "In Process", IF(COUNTIF(CHILDREN(), "Complete") = 0, "Not Started"))))

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!