Comparing 2 date fields and setting symbol

Graham.Cole

Hi.  Just getting to grips with Smartsheet.  I have pairs of date fields:  Forecast Date and Actual Date.  I would like to set a red status symbol if the Actual Date is past/older than the Forecast date.  How can I do this?  Alternatively I can set a check box if setting a symbol is not possible.

Shaine Greenwood

Hello Graham,

You can accomplish this by placing an IF statement in an RYG symbol column. An example of an IF statement is as follows:

=IF([Forecast Date]1 < [Actual Date]1, "Red")

More on RYG symbol columns can be found in the help center: https://help.smartsheet.com/articles/504619-column-types#symbols

Here's more info on creating formulas in Smartsheet: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet

This is a specific article on the IF function: https://help.smartsheet.com/function/if