Partial search for any of multi-select items in string

172 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi there, 

I'm trying to rank titles based on a multi-select. 

This is my setup:

  • title = string field containing title of a contact
  • prio1_titles = multi-select field where I'm specifying which a preferred contact should have included
  • title_rank = the formula I'm trying to create – fine if it gives out '1' for now

What I'm trying to achieve:
If the title of my contact contains any of the multi-select words I want the formula to return true.

I managed to search for the title in prio1_titles but this is not suitable for partial matches. For example if a title contains "co-founder and coo" I still want the formula to return true because of the partial match for "founder".

Screenshot 2023-01-17 at 10.13.59.png

Would appreciate any help with how to set up this formula.

I'd consider myself an experienced no-coder, have no experience with airtable scripts so far, so I would prefer a formula solution.



0 Replies 0