about automate RGY Ball

SHUIYI THAMES

Hi smartsheet friends,

I have a naive question about automating RGY Ball.

I wrote a syntax to create automate RGY Ball. Here is what I did:

1. column properties: symbol
2. =IF([forecast date]@row = TODAY(), "RED", "GREEN")

As a result, in the cell, it returns as a text "GREEN" instead of the symbol.

Could you help me to figure out what i did wrong?

Aravind GP

Hi,

Just write the formula as "Red" and "Green", instead of all in capital letters.

Aravind GP

Hi,

Just write the formula as "Red" and "Green", instead of all in capital letters.

SHUIYI THAMES

Thanks a lot, Aravind!!! It works!!