Use Find and Replace to search for specific values in a sheet and replace those values one at a time or all at once.
To use Find and Replace, open the sheet that you want to work in and press [Ctrl] + F (Windows) or [Cmd] + F (Mac) to open the find and replace form.
TIP: You can select multiple columns, rows, or cells before using the keyboard shortcut to find and replace values in only that portion of the sheet. To use find and replace on the entire sheet, make sure only one cell (or no cells) are selected before opening the form.
To find values:
- Type the value you'd like to search for in the Find field.
- Click Next or Previous to navigate to the next or previous instance of that value.
To replace values:
- Type the value you'd like to replace in the Find field.
- Type the value you'd like to replace it with in the Replace with field.
- Do either of the following:
Click Next or Previous, and then click Replace, to replace the values one at a time.
Click Replace All to replace all of the values in the sheet or selection with your Replace with value.
The number of values Smartsheet replaced will be displayed under Find what.
Smartsheet won't replace values in hidden columns or filtered rows; however, it will let you know that matching values exist. If you want to search and replace those values, you'll need to unhide the columns or remove the filter and re-display the rows.
You can replace values in any cell for which you have permissions to edit except for the following:
- Cells containing formulas
- Cells in Symbols columns that use Boolean values (checkbox, star, or flag)
- Any cell in the End Date column of a dependency-enabled project sheet
- Any cell in the Start Date column of a dependency-enabled project sheet if driven by a predecessor
- Cells containing hyperlinks and inbound cell links.
Tips and Best Practices for Find and Replace
Find and replace values in a Contact List column to easily re-assign tasks from one person to another. The found values will match the name or email address used in the Find what field. For example, if you search for email@example.com, any name in a Contact List column that is associated with the email address firstname.lastname@example.org will be found.
You can also use find and replace with most values in the Symbols columns (exceptions, noted above, are checkbox, star, or flag values). Click the drop-down arrow in any cell in a Symbols column to see the text values associated with each symbol. For example, you can find the value Yellow and replace it with Green (include the matching capitalization) to change all Yellow status balls to Green.