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

Myles Armstrong
edited 03/18/24 in Formulas and Functions

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.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!