Overall Project Status
I am trying to create an IF statement in regards to overall project status. Our goal is that if 1 ball is red, and the rest is green, then the overall project status is red. However, if only one ball is green then the project is still red.
Answers
-
Hi @Jessica Wood,
I found the attached PDF guide that explains a framework formula for implementing what teh author describes as a "weakest link" check, which is the scenario I think you are describing. Hope this helps.
Thanks,
Mark
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