Find (ctrl f) and Change (ctrl h)

CLM

How do I change a word that appears 37 times in my sheet?  Ctrl H, does not work. thanks

John Sauber

Here is what we do:

 

Filter for the word, copy and paste the text into a text editor, use find+replace, paste it back in.

 

If you are replacing the entirety of the cell, then you can simply skip the use of the external program. Selecting and pasting over a range of cells which are filtered will only modify the data which is visible, and not the data which is behind the filter.

Travis

I am happy to announce we have added a find and replace feature to Smartsheet! Read my announcement here: https://community.smartsheet.com/announcement/new-smartsheet-find-and-replace-within-sheet-and-identify-web-form-responses