NEED HELP TO RESOLVE THIS IF STATEMENT

Copper Contributor

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

 

 

 

6 Replies

@LuisCortez 

Can you post a spreadsheet with sample data?

@LuisCortez 

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. 

Capture 2.JPG

@LuisCortezI tried this way too.Capture 3.JPG

@LuisCortez 

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)