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

Find more posts tagged with

Formulas

Accepted answers

Radhika

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

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.