Need Assistance in Formulae

Radhika
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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!