Need help combining multiple sheets into one unified sheet

Hi,

I have multiple sheets that is used by my team. I was hoping to find an automation to combine all the sheets (there's about 6-7 in total), and when they click certain criteria to move it over to one sheet (this is more for metric basis and counting individual work). Currently they have been manually entering in the work.

Moving rows and copying rows doesn't work since those sheets all have about 20-30 columns. And reports don't help with graphs, since it gets posted.

Looking for anyway to bypass this, thanks!

Find more posts tagged with

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi @unanonymous

I’ve done something similar by first combining the data in a Report, then exporting it to Excel or Google Sheets, and finally importing it back into Smartsheet as a new sheet.
Just make sure to set the right filters, grouping, and summing in the report before exporting, so the imported sheet is already in good shape.

If you’re currently building the combined sheet manually, this approach should make it a lot less tedious and save you time.

unanonymous

https://community.smartsheet.com/discussion/comment/492268#Comment_492268

Hi, thank you for answering me! I guess my issue, and maybe I didn't understand your solution, was to continuously proceed with this new sheet. They use the individual sheets, and I was hoping to limit a repetition

Paul Newcome

Why exactly do reports not work?

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.