SOLVED

Multiple FIND functions

%3CLINGO-SUB%20id%3D%22lingo-sub-1467734%22%20slang%3D%22en-US%22%3EMultiple%20FIND%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1467734%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20would%20like%20to%20expand%20on%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fexamples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethis%3C%2FA%3E%20formula%20in%20my%20SharePoint%20Online%20list%20calculated%20column%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-html%22%3E%3CCODE%3E%3DIF(ISNUMBER(FIND(%22v%22%2C%5BColumn1%5D))%2C%20%22OK%22%2C%20%22Not%20OK%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EI%20would%20like%20to%20find%20multiple%20different%20separate%20sections%20of%20text%2C%20e.g.%20when%20'v'%20or%20'ab'%20or%20'de'%20is%20present%2C%20to%20return%20'OK'.%3C%2FP%3E%3CP%3EIs%20that%20possible%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1467734%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1468113%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20FIND%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1468113%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679790%22%20target%3D%22_blank%22%3E%40rhiheu%3C%2FA%3EYes%20it%20is%20possible%2C%20please%20find%20the%20test%20replication%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1592323796483.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F199044iAAFC38F18B59D987%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1592323796483.png%22%20alt%3D%22Vikram_Samal_0-1592323796483.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20formula%20will%20look%20something%20like%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(OR(ISNUMBER(FIND(%22v%22%2CValue))%2C%20ISNUMBER(FIND(%22ab%22%2CValue))%2CISNUMBER(FIND(%22de%22%2CValue)))%2C%20%22OK%22%2C%20%22Not%20OK%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EThanks%2C%3CBR%20%2F%3EVik%3CBR%20%2F%3EIf%20this%20post%20helps%2C%20then%20%3CSTRONG%3Eplease%20consider%20Accept%20it%20as%20the%20solution%3C%2FSTRONG%3E%20to%20help%20the%20other%20members%20find%20it%20more%20quickly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470151%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20FIND%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470151%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20works%20perfectly%2C%20thanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394813%22%20target%3D%22_blank%22%3E%40Vikram_Samal%3C%2FA%3E!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

I would like to expand on this formula in my SharePoint Online list calculated column:

=IF(ISNUMBER(FIND("v",[Column1])), "OK", "Not OK")

I would like to find multiple different separate sections of text, e.g. when 'v' or 'ab' or 'de' is present, to return 'OK'.

Is that possible?

Thanks.

2 Replies
Best Response confirmed by rhiheu (Occasional Contributor)
Solution

@rhiheuYes it is possible, please find the test replication:

Vikram_Samal_0-1592323796483.png

The formula will look something like this:

=IF(OR(ISNUMBER(FIND("v",Value)), ISNUMBER(FIND("ab",Value)),ISNUMBER(FIND("de",Value))), "OK", "Not OK")

Thanks,
Vik
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

That works perfectly, thanks @Vikram_Samal!