Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Auto Command based on RAG color displayed

    ✭✭✭
    in Formulas and Functions

    Hello, I want an automated response based on RAG colors displayed. This perhaps by creating a nested formulla.-see attached.

    Image
    Auto Command.png
    Uploaded 47.64 KB


    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

    · Share on FacebookShare on Twitter

    Best Answer

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

      · Share on FacebookShare on Twitter

    Answers

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

      · Share on FacebookShare on Twitter
    • ✭✭✭

      Thank you very much. This works perfect

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions