Change project status in Parent Row

Joseph Aloysias
Joseph Aloysias ✭✭✭✭✭
edited 06/19/23 in Formulas and Functions

I would like to change the parent row automatically if the status is changed other than "Planned" & "On Hold" in the status column, Please help me with the formula to achieve this.

if all the tasks are completed it should change the status to completed otherwise it should be "in progress"



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!