Clearing a smartsheet without losing the formulas.
Hello,
Is there a way to clear a smartsheet without losing the formulas?
Yvette
Answers
-
If the formula is the same throughout the entire column you can use column formulas. Right click on the formula and click "Convert to Column Formula" at the bottom of the pop-up menu. It will override any other formula or data you have in that column though. Then you can clear the sheet and the formula will stay.
I hope that helps.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives