compare multi-contacts to a text string
Hi everyone,
I am building a schedule for my team that will confirm if a combination of assigned staff 'assigned to' are trained to do a specific task 'task combos'.
the 'staff trained in this task' is a text column that is using JOIN(COLLECT) to combine contacts who are trained in a task, these are in different columns not seen below.
Because i cant join contacts in a single cell my idea was to convert 'assigned to' into a text string and compare that to the 'staff trained…" and use the checkbox to confirm if those are indeed trained staff. in the checkbox column my current 'not working' formula is
=IF(CONTAINS([text of 'assigned to']@row, [staff trained in this task]@row), 1, 0)
My problem seems to be the commas when i convert the contacts into text, i cant seem to get rid of that, however i feel there must be a way to ignore the comma and just search the names?
thanks in advance
Joe
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!