Smartsheet template with approval request

Hello,

We will need to create multiple number of sheets periodically and thinking of creating them from a Template.

The sheets will be quite basic/plain - mainly contain free text, drop down list, number and dates. I am quite sure this can be accommodated by the template.

Can the template also cater for Approval requests? It will be the same approver each time as well - so it's quite straight forward. Or is this approval request something that needs to be done manually per sheet once it's created off a template?

Thank you.

Find more posts tagged with

Templates

Sheets

Email Notifications

Comments

Andrée Starå

Hi Gery,

There are a few different ways to structure it and to answer your question about the Approval Requests. Yes, a Template can have the information included by default.

One Template per sheet
A folder used as a template for the sheets that need to be created periodically
A Workspace used as a template for the sheets that need to be regularly created

Hope that helps!

Which method would work best for you?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

gery.elrahweise

Hello,

Method 1 is probably the one that will work best. We'll create a template for sheet.

I'm still a bit unsure. Can you please confirm for me, if I understand you correctly, in the sheet template, we can include approval request - the same rule, the same approval - as part of the template?

Thank you, and sorry for repeating myself!

Andrée Starå

Ok.

Happy to help!

Yes, I can confirm that it will work. The only thing that might not stay is if you have it set up to go to specific people. If I remember correctly, it actually works, but I'm not 100% sure. It could be that the description below isn't updated.

Although all alerts & action rules are preserved in the template, any rules that are configured to be sent to specific people (as opposed to a Contact list column) will exclude the email addresses. You must re-enter these email addresses in to these types of alerts & actions rules on any new sheets created from the template.

More info: https://help.smartsheet.com/articles/522123-creating-using-templates#createtemplate

Will it work the way you need?

gery.elrahweise

Thank you, Andrea. I will give it a try, and write more comments if I need more assistance. Cheers.

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…