Automate a Parent based on a Child?


Is there a way to automate the value in a parent cell based on what's listed in the children cells? I have a sheet set up with a column to indicate if a milestone is complete or ongoing. Some rows I have this automatically changed based on the finish date, but some rows need to be confirmed by the task owner before changing to complete. I would like to have an automation that lists the parent task as complete if all its children are listed as complete. Is there a way to do that?

I did see this question was asked before, and there wasn't a way to do that, but that post was from 2018, so I was hoping that has changed.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!