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
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives