How can I have a parent card marked as "Done" if all their sub-tasks are complete

We are using the card view to provide use case testing for our clients. Currently, the sub-tasks roll up to a parent row which makes the card. However, when sub-tasks are marked done (using the checkbox functionality in cards), I can't figure out how to have the parent row automatically mark complete.

I used conditional formatting to have those checked as done turn green and then unchecked red. Currently, the card remains red even if all sub-tasks are checked as done.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!