How can I compare two lists for overlap?
Hello,
I'm trying to compare the values in two multi-selection dropdown lists to see if there's any overlap. Say both of them have options (a, b, c, d, e), and List 1 contains (b, c) and List 2 contains (c, d). Is there a way to return True because they both contain (c)?
The larger goal is using this to add a contact to specific cells to limit views in DynamicView to users that have overlaps with each other.
Answers
-
Here's what I came up with. You'd need to create a formula column for each of the multi-select dropdown choices. For example to find C:
The formula would be:
=IF(CONTAINS("c", ABCDE@row), true, false)
You can hide the formula columns once you have them built out and doing what you need.
-
Hi Matt,
That worked great. I've implemented it and it solved the problem.
Thanks bunches!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!