Importing Info and Generating New Sheets

Good day. I am wondering if there is a way to import a sheet of data and then have a workflow take that data and apply it to a current template that will generate new sheets based on that template and data.

So I have an excel sheet that contains project build IDs and turnover dates. Currently I have a template created that the team follows for each one of these builds that we use to create new sheets for each separate build. The only data we change is the title of the sheet which is the same as the build ID and the turnover date. So I would like to be able to import my sheet with the build IDs and dates and then apply that data to the template and whenever it sees a different build id and date, create a new sheet for that info based off the data and copy only that information to specific rows.

Is this something Data Shuttle could facilitate?

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

https://community.smartsheet.com/discussion/142731/importing-info-and-generating-new-sheets

Hi,

I hope you're well and safe!

Yes, it's possible.

Sometimes in my client solutions, I use an import sheet to populate the project sheet, and others. The sheet can then be used to automatically create all assets using the Premium App, Control Center.

Would that work/help?

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 the question. I appreciate it, thank you! 🙏

Paul Newcome

Not with Data Shuttle.

You would need to use other premium or 3rd party apps such as Bridge or the API to get the new sheet automatically created and the data pushed to the new sheet.

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.