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.