Parent/child roll up formula
Does anyone have feedback on the formula below? I may have some parentheses where there shouldn't be. Here is what I am trying to accomplish in the parent cell:
"Complete", if all children are "Complete"
Leave the cell blank, if all children are blank
"On Hold", if any children are "On Hold"
"Requirements Needed to Begin", if any children are "Requirements Needed to Begin"
"In Progress", if any children are "In Progress"
=IF(COUNT(CHILDREN()) = COUNTIFS(CHILDREN(), "Complete"), "Complete"), IF(COUNTIFS(CHILDREN(), 0), 0), IF(COUNTIFS(CHILDREN(), "On Hold") > 0, "On Hold"), IF(COUNTIFS(CHILDREN(), "Requirements Needed to Begin") > 0, "Requirements Needed to Begin"), IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress")
Thank you!
Answers

It looks like you have some misplaced parenthesis.
=IF(COUNT(CHILDREN()) = COUNTIFS(CHILDREN(), "Complete"), "Complete", IF(COUNTIFS(CHILDREN(), ""), "", IF(COUNTIFS(CHILDREN(), "On Hold") > 0, "On Hold", IF(COUNTIFS(CHILDREN(), "Requirements Needed to Begin") > 0, "Requirements Needed to Begin", IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress")))))
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 359 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!