Adding If Not Blank to Existing Formula
Smartsheet Community:
Do I Add If Is Not Blank to Each Part of My Current Formula or Just at the Beginning?
Current Formula:
=IF(OR(CPI@row = 1, CPI@row <= 0.95), "Green", IF(OR(CPI@row = 0.85, CPI@row <= 0.94), "Yellow", IF(OR(CPI@row = 0, CPI@row <= 0.84), "Red")))
Attempted Modified Formula But Incorrect Response Results:
=IF(OR(NOT(ISBLANK(CPI@row)), CPI@row = 1, CPI@row <= 0.95), "Green", "", IF(OR(NOT(ISBLANK(CPI@row)), CPI@row = 0.85, CPI@row <= 0.94), "Yellow", "", IF(OR(NOT(ISBLANK(CPI@row)), CPI@row = 0, CPI@row <= 0.84), "Red", "")))
Thanks
Best Answer
-
Hi @Kaleb
I think this formula is what you're after:
=IF(NOT(ISBLANK(CPI@row)), IF(OR(CPI@row = 1, CPI@row >= 0.95), "Green", IF(OR(CPI@row >= 0.85, CPI@row >= 0.94), "Yellow", IF(OR(CPI@row = 0, CPI@row <= 0.84), "Red"))), "")
Output:
If I've misunderstood something, let me know. If not, I hope this helps! 😊
Answers
-
Hi @Kaleb
I think this formula is what you're after:
=IF(NOT(ISBLANK(CPI@row)), IF(OR(CPI@row = 1, CPI@row >= 0.95), "Green", IF(OR(CPI@row >= 0.85, CPI@row >= 0.94), "Yellow", IF(OR(CPI@row = 0, CPI@row <= 0.84), "Red"))), "")
Output:
If I've misunderstood something, let me know. If not, I hope this helps! 😊
-
Yes, That Worked! I See The IF(NOT(ISBLANK(CPI@row)) is at The Beginning Only.
Thanks
-
No problem, glad it is what you're after.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!