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.
Removing Projects on an ongoing spreadsheet
Comments
-
By "projects" you're wanting move are you just talking about a row? If so, there a couple ways of doing it.
Â
1. In the row menu on the left side of the sheet there is an option to move the row to another sheet.
2. If you have the sheet you wish to move a row or "project" to up top as a shortcut tab, you can click and hold the row number of the row you wish to move and drag it up onto that sheet tab at the top.
Â
Both options will do exactly the same thing. I have one sheet of current, ongoing projects that I monitor and update. Once the project is complete I move it over to my "Archived List" which is identical to my current list when it comes to columns and layout. This way I still retain information from past projects but don't clutter up my current sheet that I look at regurlarly.
Â
Note: When moving rows from one sheet to the other, any formulas you have will not carry over, only the values.
-
I have a Parent line of Old Projects and then move the Old project below this line and make it a child of the ol project line.
I can then collapse the line or expand to see it......
-
I do the same as Zac. Â The columns of hte Current must be the same as the Archive.
Â
-
If, however, you add a column to your current list, whenever you move a row to the archived list that new column will automatically be created. Fun fact.
-
If you are moving items to the bottom of the sheet for archiving, be aware that WebForms can be setup to add to top or bottom. If set to bottom, well, that screws up your archive. Or if it doesn't, you need to add your autofill formulas and formatting to the odd data.
Neither likely a big deal, but possible annoyances.
Â
I move old projects to templates (don't count as sheets) Â and archive with the other project documentation.Â
Â
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 33 Webinars
- 7.3K Forum Archives