Making Parent Rows Display the Lowest status of their Children Rows

Options

Hey everyone, I'm looking to have my parent rows simply display the lowest status of their children rows.

My statuses are Complete, In Progress, Not Started.

Pretty basic but I keep having hang ups for some reason. I don't know if it's because some of my children rows have children of their own to break up the task into steps?

Any help would be great. Not sure if a screenshot will help as it is a very basic problem.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!