#unparseable error when creating a symbol formula

Options

Hi,

I am trying to create a formula to return a status symbol based on the date on a cell. Basically, I have a column called "Date PRF Received" and I want to put a formula in the next column to show a Red light if the date is prior to today's date and Green if the day is still in the future. I am using the formula:

=IF([Date PRF Received]@row < TODAY(), “Red”, “Green”)

But I get the following error message in the cell

Any ideas how to fix this?

Thanks.

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!