nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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.

Find more posts tagged with

Comments

MattH

Use empty quotes. Like:

=IF(ETA11 > TODAY(), "Green", IF(ETA11 < TODAY(), "Red", IF(ETA11 = "", "Yellow", ""))

richard_uy

Hi Matth, can't work, RYG ball still with Red.

Mike Wilday

Try,

=IF(ISblank(ETA11),"Yellow", IF(ETA11 > TODAY(), "Green", IF(ETA11 < TODAY(), "Red", "")))

richard_uy

It work perfectly. big thanks.

Sign in to join the conversation!

Quick Links

Trending discussions

Smartsheet and Excel
Can excel sheet be used as a reference in Smartsheet?
Why does Smartsheet show the following "You have 4 days left on your business trial plan"
I have a State account
Forms only for new row items?
Hi Can you utilize forms to make data entry easier into a row that already exists?. For instance, if I have pre-populated a sheet with 100 rows/items can I use a form to update certain columns in these rows…to make columns with multiple lines of text easier to enter? Many thanks Matt