Hi, I am trying to create a formula that will update the status for orders if they are overdue, however some orders have a revised delivery date which is an entry in another column to which I want the formula to refer if it has been filled and to use the original delivery date if it has been left blank.
Currently I have it working for the original delivery date using “IF({Actual Del. Date}>{Desired Del. Date}, “Late”, “On-Time”)”. I would like to have this remain functionally the same but to first check the column “Rev. Del. Date” and to use that instead of “Actual Del. Date” if a date has been entered.
Is this possible and if so how would I implement it?
Thanks all.
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
2