How to Make a Dynamic Formula for Multiple Searchable Values Using CONTAINS or HAS?
![System](https://us.v-cdn.net/6031209/uploads/userpics/650/n67RVONBT7K0D.png)
Answers
-
Are you able to provide screenshots for context?
-
Hi @MHumphrey,
If you haven’t already, take a look at the following resources for more information on the HAS and CONTAINS functions:
HAS is designed to work with multi-select contact list columns and multi-select dropdown columns, whereas CONTAINS won’t work with these.
What happens when you try the different options you provided of HAS or CONTAINS in your formula? If you could provide some examples of the formulas you’ve tried and the results/error messages you’re seeing, that should help us to determine what’s not quite right in the formula.
It would also be really helpful if you can provide screenshots showing how your sheets are set up, so that we can understand the ranges and exactly what you want to achieve with the formula - could you either provide screenshots of the existing sheets (with any sensitive data hidden), or create some test sheets and provide screenshots of those?
Thanks,
Georgie
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!