Cobra 1999
New Member
- Joined
- Jun 15, 2022
- Messages
- 1
- Office Version
- 365
What formula would be useful if I am attempting to route a someone
From Location (Shipper)
To Location Consignee
Locate Nearest Location to Consignee that is Shipping
From Location (Shipper)
To Location Consignee
The fields I am using are below. Is there a formula I can us to locate the next trip to be used by current location and date
From Location (Shipper)
To Location Consignee
Locate Nearest Location to Consignee that is Shipping
From Location (Shipper)
To Location Consignee
The fields I am using are below. Is there a formula I can us to locate the next trip to be used by current location and date
From | State | To | State | PICKUP_BY | DELIVER_BY | LS_PLANNED_DEPARTURE | ||
DENVER | CO | Blue Tick | WV | 6/17/2022 21:00 | 6/18/2022 01:00 | 6/14/2022 19:12 | ||
DENVER | CO | Pikesville | WY | 6/17/2022 21:00 | 6/18/2022 01:00 | 6/14/2022 19:12 | ||
Blue Tick | WV | TOPEKA | KS | 6/11/2022 11:00 | 6/16/2022 | 6/14/2022 18:35 |