0

I've tried to create a calculated column in a SharePoint list that looks for a word in the title of the list entry and then returns yes or no based on if that word is included in the title or not.

=IF((FIND("word",Title)),"Yes","No")

All of the items that have the word in the title return "yes" as expected, however the items that should return "no", actually return as "#VALUE!" and I am not sure how to solve this.

1 Answer 1

1

Adding ISERROR let's you display something else than the error message. "SEARCH" is better than "FIND" as "FIND" is case sensitive and doesn't allow wildcard characters.

=IF(ISERROR(SEARCH("Word",Title)),"Yes","No")

SharePoint: ISERROR Function

1
  • Thanks very much Christoffer, this has solved the issue! Oct 26, 2020 at 11:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.