Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using a template multiple times in a sheet?
Hi
I need a series of 8 lines (template?) repeated within a sheet along with any discussions/attachments. These lines would be added at various times throughout the year as required. I do NOT want to use a template to create a new sheet with my required lines....just to be able to add to existing sheet.
Any thoughts folks?
Comments
-
Kneve,
Templates in Smartsheet terms are for new sheets only.
What I have done is create a second sheet for the formatting / formulas I want.
You must:
1. copy a range of cells, not the rows (Copy Row is for internal to a sheet, I believe).
2. ensure the columns you want to copy are unhidden
3. columns are in the same order in the 'template' and the sheet
Template sheet saved as a favorite.
Not as fast as simple right-click, insert template, but works.
And given the frequency of use by me (low) works well.
Craig
-
Along the lines of what Craig suggested, heres what I would do:
Create a second sheet that contains the 8 rows with attachments and discussions. Whenever you need these added to your sheet, highlight the rows, right click and select Copy Row to Another Sheet and select Include Attachments and Include Discussions.
This will copy the row contents (including attachments and discussions) to your sheet. They will be added to the bottom of your sheet but you can drag and drop to rearrange as needed.
-
Good suggestion Sam.
If you haven't done (2) and (3) from my response, you will get extra columns at the end and need to reconcile, but this brings over everything.
Craig
-
Thanks guys! I'll give it a try!
-
Kneve,
Update from usage:
1. When you copy in a bunch of rows from the template, put them at the bottom of the new sheet, I thought there was an "insert here" function, but I either am misremembering or I lost it. I overwrote a bunch of rows this morning when I copied over the template rows. (No permanent scars)
2. If you have absolute references in formulas, they don't come over properly.
Easy to find and fix, but I did not have the references last time I inserted, so new to me.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives