Home

NEED HELP TO RESOLVE THIS IF STATEMENT

%3CLINGO-SUB%20id%3D%22lingo-sub-729719%22%20slang%3D%22en-US%22%3ENEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729719%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20in%20a%20dispatch%20office%20in%20a%20warehouse.%20I%20record%20the%20status%20of%20all%20trip%20numbers%20of%20company.%20Status%3A%20LOADING%2C%20SHIPPED%20OR%20DROP%20LOADED.%3C%2FP%3E%3CP%3EWe%20have%201st%20and%202nd%20shift%20group%20of%20forklift%20driver.%20I%20try%20to%20create%20a%20if%20statement%20condition.%26nbsp%3B%3C%2FP%3E%3CP%3ETRIP%20STATUS-Load%20Type-Name1-Time%20In%20A-Time%20Out%20A-Name2-Time%20In%20B-Time%20Out%20B%3C%2FP%3E%3CP%3Eif%20i%20type%20the%20time%20I%20want%20that%20the%20trip%20status%20automatically%20change%20its%20status%20from%20LOADING%20TO%20SHIPPED%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-729719%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729733%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729733%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368748%22%20target%3D%22_blank%22%3E%40LuisCortez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20post%20a%20spreadsheet%20with%20sample%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729737%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729737%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121681iC3B1C439F4BFA3B9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.JPG%22%20title%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-729803%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-729803%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368748%22%20target%3D%22_blank%22%3E%40LuisCortez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20check%20if%20Load%20Type%20is%20equal%20to%20some%20string%20AND%20Shift%20Name%20is%20within%20C3%3AC28%20range%20AND%20Time%20In%20is%20within%20O3%3AO1442%20range%20-%20when%20COUNTIF%20for%20latest%20to%20conditions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-730145%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-730145%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EI%20try%20over%20and%20over%20in%20different%20ways%20and%20nothing.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121705i2C8145DE402CBEC9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture%202.JPG%22%20title%3D%22Capture%202.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-730147%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-730147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368748%22%20target%3D%22_blank%22%3E%40LuisCortez%3C%2FA%3EI%20tried%20this%20way%20too.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121706i0A8A2AF6EB267BA3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture%203.JPG%22%20title%3D%22Capture%203.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-730328%22%20slang%3D%22en-US%22%3ERe%3A%20NEED%20HELP%20TO%20RESOLVE%20THIS%20IF%20STATEMENT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-730328%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368748%22%20target%3D%22_blank%22%3E%40LuisCortez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you'd%20like%20to%20check%20if%20K2%20is%20equal%20on%20of%20C3%3AC28%20in%20sheet%20Data%2C%20when%20formula%20is%3C%2FP%3E%0A%3CPRE%3E%3DCOUNTIF(Data!C3%3AC28%2C%20K2)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
LuisCortez
New 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)

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies