Auto Command based on RAG color displayed
Hello, I want an automated response based on RAG colors displayed. This perhaps by creating a nested formulla.-see attached.
If ResusTrolley/Cart is green, then comments should be "Excellent", otherwise "Needs updating". If Eyewash Station is green, then comments should be "Excellent", otherwise, "Needs updating"
Can any one assist with this formulla?
can this be achieved under one cell under Comments
Best Answer
-
What will the Comments say if one is green and the other is blank or red?
Put this in your Comments column, and you will see the problem.
=IF(OR([Resus Trolley/Cart]@row = "green", [Eye Wash Station]@row = "green"), "Excellent", "Needs Updating")
I almost feel like you want the opposite, if either is not Green, you want Needs Updating.
=IF(NOT(OR([Resus Trolley/Cart]@row = "green", [Eye Wash Station]@row = "green")), "Needs Updating", "Excellent")
Answers
-
What will the Comments say if one is green and the other is blank or red?
Put this in your Comments column, and you will see the problem.
=IF(OR([Resus Trolley/Cart]@row = "green", [Eye Wash Station]@row = "green"), "Excellent", "Needs Updating")
I almost feel like you want the opposite, if either is not Green, you want Needs Updating.
=IF(NOT(OR([Resus Trolley/Cart]@row = "green", [Eye Wash Station]@row = "green")), "Needs Updating", "Excellent")
-
Thank you very much. This works perfect
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!