How do I pull in two contacts into a specific cell?

I am trying to write a formula to pull in a contact based on identifying role into an assigned to cell.

So where it says Regional Admin and Manager, I want to pull in both of those contacts based on what gets entered into the Assigned To cell.

I managed if it was a single contact by using =[Assigned To]@row

I had to drag that formula though into the cells that qualify.

It would be nice to write a formula that will grab what's true based on role. That might be too extensive though.

Appreciate any help I can get!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

There is currently no easy way to populate multiple usable contacts into a single cell dynamically through a formula. You would have to create a reference table with all possible combinations and then reference that.

EmilyD

Thank you! It will work as is and maybe in the near future I can improve it with the reference table.

Happy Thanksgiving!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.