Formula Support

Stwillis ✭✭
edited 07/27/23 in Formulas and Functions


I need support on writing a formula. I want the status of the parent task to always be "Review" until all children tasks say "BI/DS/OPS Data Validation", then I want the parent status to change to "BI/DS/Ops Data Validation."

When the parent task is marked complete (dark blue row), I want all children tasks to say complete.

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!