if with blank cell, RYG ball how to become Yellow.
richard_uy
✭✭
Hi,
As per below formula, if with blank cell, How can i add the formula for RYG ball auto change to Yellow.
=IF(ETA11 > TODAY(), "Green", IF(ETA11 < TODAY(), "Red"))
Thanks in advance.
Comments
-
Use empty quotes. Like:
=IF(ETA11 > TODAY(), "Green", IF(ETA11 < TODAY(), "Red", IF(ETA11 = "", "Yellow", ""))
-
Hi Matth, can't work, RYG ball still with Red.
-
Try,
=IF(ISblank(ETA11),"Yellow", IF(ETA11 > TODAY(), "Green", IF(ETA11 < TODAY(), "Red", "")))
-
It work perfectly. big thanks.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives