I have four cells that require approval, I want to create a formula

I have four cells that require approval, I want to create a formula that says if all four cells are blank then the cell for approval status is red. If all four cells are not blank then "Green" for approved.

I am a novice user and any help would be greatly appreciated.

Thanks,

Best Answer

  • Christina09
    Christina09 ✭✭✭✭✭✭
    Answer ✓

    @Suzymae

    Please see below screenshot for the formula


    =IF(AND([Column1]@row = "", [Column2]@row = "", [Column3]@row = "",[Column4]@row = ""), "Red", IF(AND(NOT(ISBLANK([Column1]@row)), NOT(ISBLANK([Column2]@row)), NOT(ISBLANK([Column3]@row)), NOT(ISBLANK([Column4]@row))), "Green"))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!