Calculated coulmn : Check if a column value or a part of it matches specific text

Please any support what is wrong in this formula in this single column calculated column I need it to look in Title Column if it contains this word in the text (YCC) it fill the calculated column as...

admin

Lists

microsoft lists

SharePoint Online

RobElliott
Feb 14, 2022
Ghada Mehrez There's no Contain function in a SharePoint calculated column, you'd need to use Find. But the formula is going to be complicated if you are trying to see if the Title column contains YCC or INDO cement and puts in the relevant Text. What would be easier is to use 3 calculated columns:

YCC: =IF(ISERROR(FIND("YCC",Title)),"","YCC")
INDO: =IF(ISERROR(FIND("INDO Cement",Title)),"","INDO Cement")

Then combine the results of those into a third calculated column:
YCC OR INDO: CONCATENATE([YCC], [INDO])

Then just hide the YCC and INDO columns.

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

RobElliott

Silver Contributor

Feb 14, 2022

Ghada Mehrez There's no Contain function in a SharePoint calculated column, you'd need to use Find. But the formula is going to be complicated if you are trying to see if the Title column contains YCC or INDO cement and puts in the relevant Text. What would be easier is to use 3 calculated columns:

YCC: =IF(ISERROR(FIND("YCC",Title)),"","YCC")

INDO: =IF(ISERROR(FIND("INDO Cement",Title)),"","INDO Cement")

Then combine the results of those into a third calculated column:

YCC OR INDO: CONCATENATE([YCC], [INDO])

Then just hide the YCC and INDO columns.

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