Change status of a child row based on parent row
Hello, all! Is there a way to change all the statuses for child rows based on a parent row?
Let's say I have a project to grow an orchard (parent row). It would have subtasks, like buying saplings, procuring fertilizer, and creating a watering schedule (child rows). If I have to scrap the orchard project, I'd mark it as N/A, which means its child rows would also be N/A.
Can Smartsheet do this, or do I need to manually update these rows?
I appreciate your help!
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Help Article Resources
Check out the Formula Handbook template!