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
Check out the Formula Handbook template!