Forum Discussion

rhiheu's avatar
rhiheu
Copper Contributor
Jun 16, 2020
Solved

Multiple FIND functions

Hi,

I would like to expand on https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3?ui=en-us&rs=en-us&ad=us 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.

Lists
SharePoint Online
  • Vikram_Samal's avatar
    Vikram_Samal
    Jun 16, 2020

    rhiheuYes it is possible, please find the test replication:

    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.

2 Replies

  • Vikram_Samal's avatar
    Vikram_Samal
    MCT
    Jun 16, 2020

    rhiheuYes it is possible, please find the test replication:

    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.

Resources