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:
- column properties: symbol
- =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
-
Hi,
Just write the formula as "Red" and "Green", instead of all in capital letters.
Thanks,
Aravind
Associate Director
Copernicus Consulting Pte. Ltd.
P: +65 9230 5657 | E: [email protected]
Feel free to reach out for licenses, services, and training on Smartsheet
Answers
-
Hi,
Just write the formula as "Red" and "Green", instead of all in capital letters.
Thanks,
Aravind
Associate Director
Copernicus Consulting Pte. Ltd.
P: +65 9230 5657 | E: [email protected]
Feel free to reach out for licenses, services, and training on Smartsheet
-
Thanks a lot, Aravind!!! It works!!
Help Article Resources
Categories
Check out the Formula Handbook template!