Making Parent Rows Display the Lowest status of their Children Rows

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
-
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"))
-
I'm glad to hear you figured this out! Thanks for posting your solution 🙂
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!