CHILDREN formula in parent row with a Status column



I'm trying to add in a parent row, as a Status cell, this kind of formula:

If any of the children have 'In Progress' or 'Complete' in a 'Status' cell, then in the parent's 'Status' cell, should be 'In Progress' OR all of them have 'Complete' in a 'Status', then return 'Complete' OTHERWISE return 'Not Started' (doesn't matter Children are blank or have 'Not Started' staus)

I have no idea how to start... and I think this info in a parent status cell should be the fundamental scope of information.

Thank you in advance



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!