Forms to Smartsheet Workflow

Hi,

I'm trying to create a Smartsheet Form that collects issues relating to 4 different locations. In the Sheet, I have four different Rows associated with each location, that are the top of the task hierarchy.

Within the forms there is a field to choose one of said locations.

What I would like to happen is, when you input an issue into the form it will pull under the corresponding location.

Is there any way to do this?

Thank you,

Nicholas

Find more posts tagged with

Forms

Automations

Accepted answers

All comments

Andrée Starå

Hi @nlarson_PMC

I hope you're well and safe!

Not sure I follow!

If you want the submission to go to a specific sheet, you could add a so-called helper Sheet that collects all submissions and then set up a Copy/Move Row Workflow that would distribute the Issue record to the correct sheet based on the location.

Make sense?

Would 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 or/and as the accepted answer. 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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.