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.

Pop Out
Hi! How can i get an icon on each smartsheet that allows for a pop out? Some of my sheets contain this option and some dont. The icon looks like 2 arrows.
Is there a way to turn off these lines?
The gantt is looking too clutter for our liking. Is there a way to turn off the connectors lines to give a cleaner appearance for print outs?
Automations not working
Is anyone else experiencing any issues with automations not working that have been working?