what formula would I need to use for this to work

Kimberly Poletes

Good afternoon,

I am new to Smartsheet and would like to input a simple formula into my sheet. I have a column titled "Delivery date" I would like to insert a symbol or checkmark or something into another column titled "ENTER MSL" when the date in the "delivery date" column is 14 days or greater. I have tried using IF, TODAY, and COUNT, but obviously do not have the correct () or , or [ ] needed to make this work properly.

I hope I explained this correctly to get the formula needed. I appreciate your feedback and assistance to my question :)

Paul Newcome

For 14 days in the future...

=IF([Delivery Date]@row >= TODAY(14), 1)