Need Assistance in Formulae

Radhika

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

Radhika

This is not possible. So I had to change my process

heyjay

=JOIN(COLLECT(
{User Email},
{Company}, Company@row, 
{Title}, Title@row), 
", ")

Translates to something like:

=Join(Collect(
{Columns you want to join},
{Criteria Column/Range 1}, Criteria1@Row,
{Criteria Column/Range 2}, Criteria2@Row,
"Delimeter")

Radhika

@heyjay Thank you for your response. Will this apply when there are 2 titles, because I'm getting a blank result set when there are 2 values in the cell.

Radhika

This is not possible. So I had to change my process