Jun 29 2019 10:58 AM
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
Jun 29 2019 11:14 AM
Can you post a spreadsheet with sample data?
Jun 29 2019 01:46 PM
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.
Jun 30 2019 06:24 AM
@Sergei BaklanI try over and over in different ways and nothing.
Jun 30 2019 12:15 PM
If you'd like to check if K2 is equal on of C3:C28 in sheet Data, when formula is
=COUNTIF(Data!C3:C28, K2)