Happy New Years to All.
I have been struggling trying to create a formula to return TEXT based on multiple criteria.
I have 7 Columns for date inputs: Promise Date., Delivery Date, Cancelled Date, Return Date, Insp Hold Date, Insp Accept Date, Release Date.
I want them to return text in one column "Delivery Status".
I had it good until i got greedy.
I need to have my delivery status based on the last input date so I can make a report and need to keep prior date inputs for tracking reports.
Please look at my attached file for details.