Need Assistance in Formulae

Radhika ✭✭
edited 02/15/24 in Formulas and Functions

I have 2 tables as below, I need assistance in populating column Notification

Table 1

Table 2 :

Ask :

Based on the Title of the task, I want to pull all the users associated with it.

I was able to perform for one title value with Join and Collect. I need assistance modifying the logic so that if the title contains 2 values, I want to pull all the users from 2 tables associated with the title.

For eg

In row 2 of table 1, contains 2 titles Software Engineer and QA Tester then from the second sheet I want to pull all the users that are associated with the titles


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!