Formula help
Answers
-
Is there a "face-palm" emoji? I was using "Complete" in my formula and you were using "Completed". It has been a while since I have fallen victim to the "Complete" vs "Completed" conundrum, so I guess I was due.
=IF(COUNT(CHILDREN()) <> 0, IF(CONTAINS("In Progress", CHILDREN()), "In Progress", IF(COUNTIFS(CHILDREN(), "Completed") = COUNT(CHILDREN([Panel #]@row)), "Completed", IF(CONTAINS("In Progress", DESCENDANTS()), "In Progress", IF(COUNTIFS(CHILDREN(), "Completed") = COUNTIFS(CHILDREN(Task@row), "Actual"), "Completed")))))
-
Perfect, Thanks! Was that really the only thing? Because I did notice that, and had made the changes (I thought), or was there something else missing?
-
That was the only thing missing from the formula you said generated a blank cell.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!