Saving sheet as new for 2021 without data
Hallo,
I use a sheet for claimed damages. It has been filled with a huge number of data
I wonder if there is a way to save the sheet as a new and blank sheet (with the automatizations, formats a.s.o.)
for 2021 and following years.
If I just save it as new and than delete the data of 2020 new issues will be added automatically in row 700+
Hope you have a nice idea ;-)
Best Answer
-
Hi @Jörg Schmidt Novum Hospitality
Reading this like this I would suggest to save the whole sheet as a new template, and saves everything.
Then creates new sheet out of the templates for 2021+ years
Also make sure when you delete rows to effectively removing all the lines.
Selecting all datas and pressing delete just remove Data.
In your case, click right and select "delete".
Your sheet will be blank and your first line will be row 1 not 700+ :)
Answers
-
Hi @Jörg Schmidt Novum Hospitality
Reading this like this I would suggest to save the whole sheet as a new template, and saves everything.
Then creates new sheet out of the templates for 2021+ years
Also make sure when you delete rows to effectively removing all the lines.
Selecting all datas and pressing delete just remove Data.
In your case, click right and select "delete".
Your sheet will be blank and your first line will be row 1 not 700+ :)
-
hope it works - Thank you ;-)
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives