Formula to blank cell in column if another column cell is blank?

Myles Armstrong

I this formula in the "Drawings Status" column =IF(AND([Drawings Received]@row = "", [Drawings Quoted]@row <= TODAY()), "Yellow", "Green"). The problem is I want the "Drawings Status" column to be blank if the "Drawings Quoted" column is blank. Right now the status column will turn yellow if its blank. In short I'd like a formula that will turn the status column green if the "Drawings Received column is populated, turn the status column yellow if we pass the date in the "Drawings Quoted" column by 1 day, and turn the status column blank if the "drawings Quoted" column is blank.

DKazatsky2

Hi @Myles Armstrong,

Give this a try. =IF(ISBLANK([Drawings Quoted]@row), "", IF(AND([Drawings Received]@row = "", [Drawings Quoted]@row <= TODAY()), "Yellow", "Green"))

Hope this helps,

Dave