Why teams use it
One change, every sheet
A preview spans any number of sheets at once, and looks in the Sheet Summary as well as the grid — where a client or project name most often hides, and what a sheet-by-sheet sweep most often misses.
Preview before you commit
A dry run shows exactly how many cells, rows and Sheet Summary fields would change, with the first ten before/after examples and a Show more button to page through the rest, before a single edit is written.
Precise matching
Match case, whole words, or whole-cell only. Rewrites text in Text/Number, dropdown and multi-select columns; dates, checkboxes, numbers, formulas and links are never touched.
How it works
Pick your sheets
Choose the sheets to search across. Previews can span any number of sheets; one Apply writes to a few at a time (see the usage limit below).
Enter find & replace
Type what to find and what to replace it with, and set your matching options.
Review the dry run, then apply
Check the counts and page through the before/after examples, untick any rows to skip, then approve to update the selected sheets at once.
Frequently asked questions
Can I find and replace across multiple Smartsheets at once?
Yes. Select the sheets and the matching text is replaced across all of them in a single pass, instead of opening each sheet one by one. Previews are unlimited; each Apply writes to a handful of sheets at a time — the exact number is in the usage-limit answer below.
Will it change anything before I confirm?
No. Every run starts as a dry run that shows exactly how many cells and rows would change, with before/after examples you can page through in full, so nothing is written until you approve it.
Which cells does it change?
Text values in Text/Number, dropdown and multi-select columns, and you can match case, match whole words only, or replace only when the whole cell matches exactly. Date, contact, checkbox and symbol columns are not searched, and numeric values stay numbers — so a replace can never silently retype a column. Formula cells, cell links and images are skipped too.
Does it search the Sheet Summary?
Yes. Text-bearing Sheet Summary fields are searched alongside the grid and listed separately in the preview, with a single tickbox to leave them out. They are a common home for a project or client name — and the row that displays one is usually a formula, which is never overwritten. Summary fields that carry a formula, or that are locked for you, are skipped for the same reason their cell equivalents are.
Is there a usage limit?
Previews and dry runs are unlimited and never count. Applying changes (a real write) is capped at 3 bulk runs per account per day while the tool is free, and a single run can span up to 5 sheets. The counter resets daily.
Prefer to do it by hand first?
How to use Smartsheet's built-in find and replace in one sheet, its limits, and how to replace a value across many sheets with a dry-run preview.
Find and Replace in Smartsheet →Ready to get started?
Connect your Smartsheet account and try it in minutes.
Connect Smartsheet to Start