NOT(ISBLANK) formula

I have a status column (Red, Yellow, Green) that changes with the number of days in another column. I am trying to get the status column to be blank once another column receives data and I can't make it work. This is the formula I'm trying to use:

=IF(NOT(ISBLANK([AWARD #]@ROW), "", (IF(ISBLANK([Days PR Approved]@row), " ", IF([Days PR Approved]@row > 60, "Red", IF([Days PR Approved]@row > 30, "Yellow", "Green"))))))

This is the original working formula to set the status once there is a date in "Days PR Approved":

=IF(ISBLANK([Days PR Approved]@row), " ", IF([Days PR Approved]@row > 60, "Red", IF([Days PR Approved]@row > 30, "Yellow", "Green")))

Once I have any data in the column "Award #", I would like the status column to be blanked out or to say something like "completed". Can someone help me? Sorry I don't know how to post it with the colors!

Thanks for the help!

Best Answer

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Answer ✓

    Try this slight variation. You have to close the NOT and ISBLANK formulas with ending parenthesis to continue working on the rest of the IF statement. This should do the trick. Let me know if it works.

    =IF(NOT(ISBLANK([AWARD #]@ROW)), "", IF(ISBLANK([Days PR Approved]@row), " ", IF([Days PR Approved]@row > 60, "Red", IF([Days PR Approved]@row > 30, "Yellow", "Green")))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!