Can you automatically populate the Owners list?

Karrie

I have two columns: Task Team & Task Owner(s)

Is it possible to automatically populate the Task Owner(s) column based on the value entered in the Task Team column?

Example:

If Task Team = Technical, then Task Owner(s) = Bob

If Task Team = Training, then Task Owner(s) = Kathy and John

Find more posts tagged with

Formulas

Accepted answers

All comments

Dakota Haeffner

@Karrie,

Yes totally,

If you are trying to populat a Contact List field I recommend using their email. For example:

=IF([Task Team]@row="Techincal", "bob@techincal.com", IF([Task Team]@row="Training", "kathy@training.com; John@training.com", ""))

Karrie

https://community.smartsheet.com/discussion/comment/436685#Comment_436685

Thanks! I tried that and it looks like the IF formula doesn't select the Smartsheet Contact.

I am assuming that it likely isn't populate to have a formula select the actual contact and it can only display the email in a form as text. Is that correct?

Dakota Haeffner

There is probably some syntax-genius who could make it happen, but I've never got it to work with the contact name. I use the email so automations continue to work.

Karrie

https://community.smartsheet.com/discussion/comment/436882#Comment_436882

Thanks! I actually just saw that Smartsheet has an Automated Workflow that will populate a contact field with the actual Smartsheet contacts.

Dakota Haeffner

@Karrie Awesome! 🤩

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.