Contact Sheet Help

Hi Community,

I have created a "phone book" of names and email addresses for contractors in my organization. Each of the individuals has a row ID that is auto-number generated by smartsheet.

Each of these individuals will be assigned to (usually) several projects during each year. I was thinking of assigning each project a row ID as well, so I can use that to link these projects (and the project members) to various other sheets.

I am stuck at being able to link multiple email addresses in each cell or row, for each project. I'm sure there's a better way, help?

Find more posts tagged with

sheet reference

Accepted answers

All comments

jjg279

Hey @jmaxbr , I was actually just looking at this today, and it doesn't appear to be possible via formula (Index/Match) with the core Smartsheet product. You can manually add multiple contacts to a cell by selecting the "Allow multiple contacts per cell" in the column set-up.

Here is a link to an excellent resource covering the topic:

https://community.smartsheet.com/discussion/123433/combine-emails-into-a-multiple-contact-column-multi-contact-column

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.