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
-
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
-
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")))
-
Thank you for your response - I tried it and still received an "Unparseable" Error.
-
Actually - it did fix it! I had to type it in rather than copy/paste and it worked! Thank you!
-
Hmmm. There must be some rogue smart quotes in there. Strange. But I am glad it works for you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!