about automate RGY Ball

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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!