Updating Overall Status based on 3 other Statuses
Hello, I need help writing a formula for the Overall Health cell based on the Scope Health, Budget Health, and Schedule Health cells.
If any of the 3 cells are yellow, Overall is yellow. If any of the 3 cells are red, Overall is red. If all 3 are green, overall is green.
Best Answer
-
Hi @Bvinston
Please see if this will work for you:
=IF(CONTAINS("Red", [Scope Health]@row:[Schedule Health]@row), "Red", IF(CONTAINS("Yellow", [Scope Health]@row:[Schedule Health]@row), "Yellow", IF(CONTAINS("green", [Scope Health]@row:[Schedule Health]@row), "Green", "")))
Hope this helps!
Answers
-
Hi @Bvinston
Please see if this will work for you:
=IF(CONTAINS("Red", [Scope Health]@row:[Schedule Health]@row), "Red", IF(CONTAINS("Yellow", [Scope Health]@row:[Schedule Health]@row), "Yellow", IF(CONTAINS("green", [Scope Health]@row:[Schedule Health]@row), "Green", "")))
Hope this helps!
-
@ker9 That worked, thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!