It would be extremely useful for automation to create a new sheet using a custom template. For example, if a cell changes to a specific value, it automatically creates a sheet or sets of sheets from a custom template depending on the selection.
Sign in to see the current vote count, add your own vote, or leave a comment.
This would be very useful for me as well. I'd like to create estimate templates for each project. I'd like for an automation to copy information (customer name, project number, address, etc.) from a row to a new sheet from a template sheet that I can then work in. I'd have a new sheet for each row (project). I could enter all the cost items for a particular project and have them total a sum, add tax, and maybe even reference back into my parent sheet with the total project estimate amount.
Right now, I have to use a completely separate document outside of Smartsheet and manually enter duplicate project information (which leaves room for errors)- or, I would have to manually copy a template each time I need to use it (and still manually enter all that duplicate project information). It's hard enough getting non-tech savvy people to use a new program, I'm trying not to add unnecessary tediousness to their new way of doing things as well.
I am trying to take a row in one sheet to create a new sheet from a template and plug in the information into a specific column in the new sheet. Hopefully smartsheet will take some action with this idea...
Hi whan, we can do this through the API if you’re interested in going that route. Otherwise, this is what control center was built for. It’s a premium app through SS
Please do this. Having it as a premium product on an already premium product is just gouging.
Current state: After every quarter ends, the items within the sheet are manually moved to a newly created sheet.
Proposed state: After every quarter, the items within the sheet automatically move to a newly created sheet that is created by automation.
I have a workflow with nearly 40 automations, half of which are email-based requests for updates with various sets of triggers. While I know the automations work, due to months of testing, when our system went live to the institution, I became very worried that the automations wouldn't run and I'd have no idea whether or…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.
