sosl search not working for Text Formula

  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hello,

I've created a table with a search box in it, which I want to search all text fields.

Additionally, I also want it to search one specific multipicklist, and the related account name.

I added a UX only field with a text formula to include the account name as it didn't search reference fields, and that worked great. However I've done the same for the multipicklist as can't get that to work. I've checked & the value appears as I would expect it to, but just isn't being picked up.

Any ideas?

Thanks!
Photo of Laura Burnett

Laura Burnett

  • 588 Points 500 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Laura,

SOSL does not support search on picklist fields.  See this feature request on the Salesforce Success Community for some detail->  https://success.salesforce.com/ideaView?id=08730000000BrnQAAS

Change your formula field to a 'Text' field and add a workflow to update the field with the values of the pick list field.  You can also add the Account.Name field so that you have an 'all in one' search field.

Thanks,

Bill