Status Rollup to Parent
I've seen some very similar solutions to my problem, but not quite what I am looking for.
My Smartsheet plan has a status column and is using dependencies. My choices in the status column are (Not Started, In Progress, At Risk, and Complete). I would like to create a formula that automatically rolls up the parent of each child status. If one child task is "IN Progress" then the parent task is "In Progress. If no child task, has started, then the Parent Task is "Not Started". If one child task is "At Risk" then the Parent task is at Risk. At Risk is the predominant concern. If we have a mix of "At Risk and "in Progress" then, At Risk should be displayed.
I appreciate any help you can offer.
Help Article Resources
Check out the Formula Handbook template!