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.

Auto Command.png

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

Find more posts tagged with

Accepted answers

James Keuning

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")

All comments

James Keuning

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")

Vinton Douglas

Thank you very much. This works perfect

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.