I work in a dispatch office in a warehouse. I record the status of all trip numbers of company. Status: LOADING, SHIPPED OR DROP LOADED.
We have 1st and 2nd shift group of forklift driver. I try to create a if statement condition.
TRIP STATUS-Load Type-Name1-Time In A-Time Out A-Name2-Time In B-Time Out B
if i type the time I want that the trip status automatically change its status from LOADING TO SHIPPED
Can you post a spreadsheet with sample data?
If you check if Load Type is equal to some string AND Shift Name is within C3:C28 range AND Time In is within O3:O1442 range - when COUNTIF for latest to conditions.
@Sergei BaklanI try over and over in different ways and nothing.
@LuisCortezI tried this way too.
If you'd like to check if K2 is equal on of C3:C28 in sheet Data, when formula is