Formula for RYG

Jason E

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

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