Making Parent Rows Display the Lowest status of their Children Rows

Walter Mootz

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.

Walter Mootz

Figured out my problem, just had an extra " in my formula.

=IF(COUNTIF(CHILDREN(), "Not Started") >= 0, "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", "Complete"))

Genevieve P.

Hi @Walter Mootz

I'm glad to hear you figured this out! Thanks for posting your solution 🙂