Forum Discussion
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...
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 Try using:
=IF(INT(FIND("test";"t"))>0;"Yes";"No")
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- thanks, that works 🙂
