Forum Discussion

gluehbirne's avatar
gluehbirne
Copper Contributor
Dec 09, 2022
Solved

Sharepoint formula find

Hi,   i try to create a simple formula in sharepoint for a calculated column, but i am not really successfull.   I want to search a certain character / string in a string. if it is found, show "y...
sharepoint
  • RobElliott's avatar
    RobElliott
    Dec 09, 2022

    gluehbirne the FIND function in the formula is to find a character or string in a column in your SharePoint list. I don't actually know why this works but a formula like this which is looking for the letter J in the names in the Title column of my list works!

    =IF(ISNUMBER(FIND("J",Title)),"Yes","No")

     

    And the results are:

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

RobElliott's avatar
RobElliott
Silver Contributor
Dec 09, 2022

gluehbirne the FIND function in the formula is to find a character or string in a column in your SharePoint list. I don't actually know why this works but a formula like this which is looking for the letter J in the names in the Title column of my list works!

=IF(ISNUMBER(FIND("J",Title)),"Yes","No")

 

And the results are:

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

  • gluehbirne's avatar
    gluehbirne
    Copper Contributor
    Dec 10, 2022
    thanks, that also works 🙂

Resources