Generate for cells a new line in a sheet

Hello,

we have a sheet where operators are putting in data via a form. We want them to enter various machine breakdowns there. So there are fields in the form named "breakdown 1", "breakdown 2" and so on.

In the sheet i get then a line with different breakdowns listed in the columns "breakdown 1", "breakdown 2" and so on. I now want to create a seperate line in a new sheet for every cell that contains a breakdown.

Its easy to copy a line which contains a breakdown via automation to another sheet. But i dont know if and how i can then make from the filled in cells a new line each.

Maybe some smart person can help me with this.

Find more posts tagged with

Automations

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/141374/generate-for-cells-a-new-line-in-a-sheet

Hi,

I hope you're well and safe!

Would this be helpful?

I developed a solution using two forms (or the same form with conditional logic) that can be used to submit the main information and then the additional information on a new row for each subsequent submission after the first.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer. I appreciate it, thank you! 🙏

Paul Newcome

@pscl_see Here is a method I developed that should work for you:

https://community.smartsheet.com/discussion/119380/split-multiple-selections-in-single-form-into-individual-rows-core-product

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