Status Change RYG for Pass or Fail
I have a sheet with 20 different [Pass Fail 1], [Pass Fail 2], [Pass Fail 3], etc.. columns that if any Fail I would like the status RYG to turn Red. Then if all Pass to be Green. I have never created a formula that has a range of columns I want it to validate as a whole. Any suggestions?
Best Answer
-
If the columns are all next to each other you can do this in the RYG column:
=IF(CONTAINS("FAIL", [Pass Fail 1]@row: [Pass Fail 20]@row), "Red", "Green")
This will turn the RYG column ball Red if ANY of the Pass Fail columns have "FAIL" in them, otherwise it will turn green.
Let me know if that helps or you need any further help!
-Jon Mark
Answers
-
If the columns are all next to each other you can do this in the RYG column:
=IF(CONTAINS("FAIL", [Pass Fail 1]@row: [Pass Fail 20]@row), "Red", "Green")
This will turn the RYG column ball Red if ANY of the Pass Fail columns have "FAIL" in them, otherwise it will turn green.
Let me know if that helps or you need any further help!
-Jon Mark
-
Hi Jon,
They weren't right next to each other. There were columns in between with other parameters. I gave it a shot and it worked beautifully!!! Thank you so much.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!