CHILDREN formula in parent row with a Status column

Options

Hi, 

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

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!