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.
Help Article Resources
Check out the Formula Handbook template!