Checkbox condition in a child row, conditional formatting of parent?

Suzanne Raphael
Suzanne Raphael ✭✭✭
edited 12/09/19 in Formulas and Functions

I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children.

I would like any parent row to turn red if any of its children fail a test, as noted by a "Fail" checkbox column, and bonus points for conversely turning green when all of the children have passed (as denoted by a "Pass" checkbox column).





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!