Automations from a Template are now Broken in existing sheets

Hi Community!

I'm having a problem with automations. I added new automations to my template that was originally used to create some existing projects.

Automations on the Existing Projects.png

Once I added the automations to the template, existing projects immediately inherited the new automations and now they're ALL broken. See screenshots. When I tried to start over and delete all the workflows in the old project, Smartsheet started to delete working automations in the template. How are they linked and is it possible to unlink them? The existing projects are already populated with data that will be very labor intensive to replace.

Thanks for the help!

Aja

Find more posts tagged with

Templates

Automations

Workflows in Smartsheet

Accepted answers

Darren Mullen

@Aja

When you have automations that are send to a specific person, you have to redo them in the new sheets.

Solution?

Create contact columns in your template with the names, and then use the contact column in your automation. Then they'll stay intact.

As an even better solution, create a contact lookup sheet, link it to the contact columns in your template. Then when you need to add, remove, or change a contact you do it in one place and it propagates to ALL your linked sheets!

All comments

Darren Mullen

@Aja

When you have automations that are send to a specific person, you have to redo them in the new sheets.

Solution?

Create contact columns in your template with the names, and then use the contact column in your automation. Then they'll stay intact.

Aja

@Darren Mullen Great suggestion, thank you! It will be helpful when we have multiple projects.

Darren Mullen

@Aja You're welcome! There's always more than one way to do things, so that's just a suggestion :)

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.