Find and Replace in Smartsheet
Smartsheet does have a built-in find and replace — but it works one sheet at a time. Here is how to use it, and what to do when the value you need to change appears across dozens of sheets.
Find and replace within one sheet
Use Grid View and cells you have permission to edit. Select a range first to restrict replacement to that selection; select only one cell or no cells to search the whole sheet.
- Press Ctrl+F (Windows) or Cmd+F (Mac) to open Find, then switch to the Replace option.
- Type the text to find and the text to replace it with.
- Use the options to narrow matching (such as matching the entire cell) if you need precision.
- Step through matches replacing one at a time, or replace all matches in the sheet at once.
The limits of the built-in tool
The built-in dialog is scoped to the sheet you have open. When a client is renamed, a status label changes, or a project code is retired, that value usually lives in many sheets — and each one means opening the sheet, running the same replace, and trusting you did not miss one.
There is also no overall preview: you cannot see how many cells would change across your whole workspace before committing.
Replace works in Grid View and excludes hidden columns and filtered-out rows. It also skips formulas, Boolean symbols such as checkboxes, stars and flags, hyperlinks, inbound cell links, and certain dependency-driven dates. Unhide columns and remove filters if those values should be included.
Find and replace across many sheets at once
Our Find & Replace tool runs the same operation across every sheet you select in one pass. Each run starts as a dry run: see the total affected rows, cells and summary fields per sheet, then page through the proposed changes — unticking any row you want left alone — before applying. Case, whole-word and whole-cell matching are supported. Worth knowing where it looks: it rewrites text in Text/Number, dropdown and multi-select columns, so date, contact, checkbox and symbol columns are not searched, and numbers stay numbers. Formula cells, cell links and images are skipped. Changing plain text can still affect IDs, lookup matches, automation conditions and downstream processes. Review the proposed changes and affected dependencies before applying.
It searches the Sheet Summary as well as the grid. A client or project name often lives up there as well as in the rows, and a sweep that only looks at cells leaves it behind on every sheet it touches. Matching summary fields are counted and listed separately from cells in the preview, with a single tickbox to leave them out of the run entirely. Summary fields carrying a formula, or locked for you, are skipped for the same reasons their cell equivalents are.
Official Smartsheet documentation: Find and replace scope and exceptions.
Do it in one pass instead
Smartsheet's built-in find and replace stops at the sheet you have open. Run one replacement across every sheet you select, with a dry-run preview first.
Try Find & Replace FreeFrequently asked questions
Does Smartsheet have a find and replace feature?
Yes. In Grid View, press Ctrl+F (Cmd+F on Mac). It operates on the current sheet or a selected range, subject to editing permissions and cell-type exclusions.
Can I find and replace across multiple Smartsheets at once?
Not with the built-in tool. A bulk find-and-replace tool runs the same replacement across every sheet you select in a single pass, covering each sheet's summary fields as well as its grid, with a dry-run preview of every change first.
Will a bulk replace break my formulas or cell links?
Our tool skips formula cells, cell links, images and numeric values, and rewrites text only in supported Text/Number, dropdown and multi-select columns — in the Sheet Summary as well as the grid, where summary fields holding a formula are likewise left alone. This is not a guarantee that downstream behaviour stays unchanged: edited text may be used as an ID, lookup key or automation condition. Review the preview and dependencies before applying.