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