# NOT(ISBLANK) formula

Options
✭✭

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!

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

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

• ✭✭
Options

Thank you for your response - I tried it and still received an "Unparseable" Error.

• ✭✭
Options

Actually - it did fix it! I had to type it in rather than copy/paste and it worked! Thank you!

• ✭✭✭✭✭✭
Options

Hmmm. There must be some rogue smart quotes in there. Strange. But I am glad it works for you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!