Parent Row Status Roll Up


I'm looking for help on a formula I have yet to find exactly what I am looking for. I have found a couple of others I have been tweaking, but not working exactly how I would like. I'm looking for a formula to roll up the status of children status to the parent row. Here is the breakdown:

If all statuses are Not Started - Roll up is "Not Started"

If any status is In Progress - Roll up is "In Progress"

If all statuses are Complete - Roll up is "Complete"

If any child is "N/A" - it is counted as "Complete"

Any help would be greatly appreciated!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!