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
Help Article Resources
Check out the Formula Handbook template!