If statement with dates

Hi there,

I am trying to put a formula in a symbol column (Yes, Hold, No options) and want the formula to make the symbol for "Hold" if the due date is within 14 days of TODAY. This is the formula I have come up with but I am not getting the "Hold" portion

=IF([Due Date]@row < TODAY(), "No", IF([Due Date]@row < TODAY(-14), "Hold", IF(Status@row = "Complete", "Yes", "")))

Anyone have thoughts on that? I am sure my error is in the TODAY(-14) section but not sure what would fix it.

I appreciate your help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!