Workflow Automation

Hi,

Do you know if there is a way to build master list of workflows and then select from those when you create a new sheet that you want to apply to that sheet?

My thoughts for this is to create a template with these workflows built in and then apply ? Only catch is if you add a new requirement and update your template the other sheets (active programs) will require a manual workflow update per sheet.

For example...As as new requirements are needed you can create a new workflow within a "master workflows" and you can then select the sheets you want that workflow to apply vs having to update each sheet?

Does this exist?

Thanks,

Find more posts tagged with

Accepted answers

Cassie_Hall

Hi All,

I wanted to share this update as SS was able to provide a solution and thought this could help others.

In Sheet --> Make the Column Type "Contact List" --> do not restrict to list values only & do not need to add pre-populated list of contacts.

On the Form --> Make sure that field is set for email address request (ex: Rep Email or Submitter Email) and have that field set for email.

In the Workflow --> Select Alert someone --> Send to contacts in a cell --> Pick that column name set to contact list (ex: Rep Email or Submitter Email) and it will alert the email in this cell

Automation Permissions --> need to be set at "Unrestricted"

Thanks!

All comments

Andrée Starå

Hi @Cassie_Hall

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Cassie_Hall

https://community.smartsheet.com/discussion/comment/323186#Comment_323186

Thank you!

Andrée Starå

@Cassie_Hall

Happy to help!

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

Cassie_Hall

Hi All,

I wanted to share this update as SS was able to provide a solution and thought this could help others.

In Sheet --> Make the Column Type "Contact List" --> do not restrict to list values only & do not need to add pre-populated list of contacts.

On the Form --> Make sure that field is set for email address request (ex: Rep Email or Submitter Email) and have that field set for email.

In the Workflow --> Select Alert someone --> Send to contacts in a cell --> Pick that column name set to contact list (ex: Rep Email or Submitter Email) and it will alert the email in this cell

Automation Permissions --> need to be set at "Unrestricted"

Thanks!

Andrée Starå

@Cassie_Hall

Excellent!

Glad you got it working!

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.