Contact Automation - Resource Manager

Hello Community-

I am trying to automate contacts into tasks based upon role using a metadata column for a timing plan vs. having to fill out each contact across 50+ milestones....

The problem is we use Smartsheet resource manager and the contact column does not allow formulas to grab the contact from the metadata column based on role.... I looked at automation options and this will not help either.

Note: Lead column is a contact column attached to Smartsheet Resource manager... Metadata column is contact column but can have other values...

Any ideas? Thanks-

Find more posts tagged with

Project Management

Resource Management

Accepted answers

All comments

Andrée Starå

Hi @Jim Schaffhausen

I hope you're well and safe!

It's untested, but it might work using cell-linking instead.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jim Schaffhausen

@Andrée Starå Hi Andree - Cell linking does not work for the "lead" column since this is tied to Resource Manager. The lead column will not allow any formulas such as cell linking.

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.