Welcome!

if with blank cell, RYG ball how to become Yellow.

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.

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.

Ownership question
This discussion was created from comments split from: Plan Asset Manager - will it capture orphaned assets already in the system?.
Can "Viewers" download/export sheets?
In the new USM, are users who are designated as Viewers only able to download/export sheets they are given access to e.g. to Excel?
Timeline Chart on Dashboard
I just tried to create my first dashboard using the timeline chart widget. I have set it to open the source data when clicked however it does not work. I've done this multiple times without success. It seems this is not actually an option even though you can select it in the settings. Can someone verify this or is there…