Dynamic contact column

Majkoss

Hello, is there any way to create a contact column that would dynamicallly change based on a different column?

So for example

I have 4 columns

Product ID, Selling countries In Progress, Selling Countries Completed, Marketing team.

The column Marketing team should be automatically populated based on an external table:

Poland - Person A

Germany - Person B

Switzerland - Person C

France - Person D

If the product is going to be sold in all the countries, smartsheet should assign 4 marketing people.

Once Person B finish their task they would change the data in "Selling Countries completed" which would delete the specific country from "Selling countries in progress" and delete the person from "Marketing team".

Example:

Product1234 | Poland, Germany | |Peter, George

(George adding Germany to the 3rd column)

Result in the file

Product1234 | Poland | Germany |Peter

Find more posts tagged with

Accepted answers

All comments

Adam Murphy

I would probably do this with IF statements joined by +, something like:

=IF(CONTAINS("Poland", Country@row), INDEX({Marketing Person}, MATCH({Country}, "Germany"), 0) + =IF(CONTAINS("Germany", Country@row), INDEX({Marketing Person}, MATCH({Country}, "Poland"), 0) + …

Would that work?

Majkoss

the fomula you provided is changing the contact column to text, also you did + and = which I think is incorrect

Genevieve P.

Hi @Majkoss

Have you looked into using an automated workflow instead of a Formula? This would allow flexibility in case the original assignment is incorrect for one specific row.

Based on your scenario, I would create multiple, separate workflows each with a trigger for when the Country is added/changed to a specific value. That way you can use the Assign Someone workflow to assign people to a multi-select Contact column.

Here's more information: https://help.smartsheet.com/articles/2482227-assign-people-in-an-automated-workflow

Cheers,
Genevieve

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.