Automation to remove formula?
Hi,
Due to our need to regularly archive data because of sheet limits on data we often see cross-sheet formulas break. While the value that the formula used to pull is visible on the cell history it would be better if we could set a time limit on the formula, allowing it to display the value after a certain amount of time. Is there an existing process that allows this? Or is the only way to do this to create a row copy/move automation?
Answers
-
Can you use a Move automation to move the records to a different sheet? The move will move the value in the cell, not the formula (according to my experience).
-
At this time the only options are copy or move row automations. Feel free to Submit a Product Enhancement Request when you are able.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!