Ability to Find & Replace text in Formulas

Hi Team,

I am aware that this functionality isn't currently available. But, as someone who works on rows & rows of data every day, replacing values in a formula using the Find & Replace feature is extremely helpful and time-saving.

As I type this, I have the daunting task of going back to my sheet on SmartSheets and manually changing every single cell with a formula which will take me hours to complete. Can we please enable this feature?

Regards

Sowmya

Sign in to vote!

Find more posts tagged with

Formulas

On Radar

Comments

NeilKY

I just found this when trying to see if a "Search for text in formula" feature request had been put in. I NEED this :)

Paul Newcome

@Shonnify You said:

"The formulas, or find and replace options do not work well with hidden, closed or indented formats. We also need an "expand all" option to help with this. Otherwise, you have to open each + separately."

If you right click on the Primary Column header, there should be an option to "Expand All" which I believe is exactly what you are looking for in that particular comment…

NeilKY

Please add this feature. we need more votes

Jessica Limke

Having the ability to find and replace items in formulas would be incredibly helpful and save time as we update certain sheets each year.

PageyP93

THIS WOULD SAVE ME HOURRRRRRRSSSSS!!!!!!!!!!

Chris_C

This would save me hours and hours. I have multiple formulas where the formula structure is the same but the filter criteria is the only thing different. Being able to find & replace that criteria would be incredible.

NeilKY

I honestly believe this is by far the MOST IMPORTANT feature Smartsheet should/could add. I cannot believe it's not even in planning.

ssagers

I need this feature, too. Every quarter I have to go in and adjust formulas. It would be so much easier to have a find/replace in formulas option.

cpirringer

Absolutely, this feature would be SO helpful.

Alywilk

this would be very helpful. I have sheets/dashboards i have to duplicate every quarter or year and i just copy/paste from the previous version but then I have to go in an update all the dates in my formula. If there was a fast way to update all the formulas that would be nice such as a find and replace

Quick Links

Trending ideas

Report Widget Capability - Drag & Drop to create Report Widget in Dashboard from Workspace Panel
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
Asset Sharing should default to View, not Edit
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.