Sorry for the confusion.
I need to know for each division if the order is under 999 units, the oldest order date.
If there is no order for that division in the list, I need it to say "Current".
Same scenario for orders over 1000 units
Next, for the days behind, I need it to show "Current" if the order is within the 2 day turn time goal.
If it is past that timeframe, I need the days behind the order is.
Make sense?
EXAMPLE 2.23.24.xlsx
Bookmarks