Formula for RYG


I'm looking for a formula that would turn the cell within the Status Column R or G based on if specific cells within the row are filled out vs blank. For example, all identified cells are completed so it's green or one cell is missing data so it's Yellow, and none of the identified cells have info so it's Red.


  • Devin Lee
    Devin Lee ✭✭✭✭✭

    Hey @Jason E

    Something like this should work. Just change the column names to match and add/remove conditions as needed.

    =IF(AND(ISBLANK(A@row), ISBLANK(B@row), ISBLANK(C@row)), "Red", IF((AND(NOT(ISBLANK(A@row)), NOT(ISBLANK(B@row)), NOT(ISBLANK(C@row)))), "Green", "Yellow"))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!