Find and replace formulas?

Does anyone know of a way to find and replace formulas in my sheet? Or to find and replace a portion of a formula that exists throughout my sheet?
Answers
-
Mike, I am following your post. From all of my research on the Smartsheet community, I believe this feature does not currently exist. Casting my vote for this to be implemented.
-
Thanks. Please submit a product enhancement request.
-
Smartsheet are currently asking us to fill in the survey about the Community, so when I filled mine in I suggested that there should be a way of referencing a enhancement request back to the community, seeing as there are a lot of threads like this.
I've also suggested it might make sense to have a button that will create an enhancement request from the discussion!!! I'd be going round creating them right left and centre if they do that, as sometimes I'm just too busy to actually fill in a request at the time, especially as I've usually just found out there's no simple solution and I have to do a workaround!
-
I agree this is needed. I have a formula that is exactly the same except for the search criteria in a VLookup and I have to manually update the information for every cell. Another option, which I found out is not available that would avoid the the manual work, would be to allow us to reference the title of the column in a formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!