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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!