NOT(ISBLANK) formula

CJ Koan

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!

Mike Wilday

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

Mike Wilday

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

CJ Koan

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

CJ Koan

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

Mike Wilday

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