Smartsheet How-To Guides
Step-by-step guides to the Smartsheet jobs that are quick once and painful forty times. Each one covers the built-in manual method first — including what it does and doesn’t do to your data — before showing the bulk alternative.
-
How to Rename Columns in Smartsheet
How to rename a column in Smartsheet, why it does not break your formulas, what it means for reports and cross-sheet references, and how to rename across many sheets at once.
Updated 2026-07-24 -
How to See Who Has Access to a Smartsheet
Check who a Smartsheet is shared with, what the admin Sheet Access report covers, and how to audit every collaborator — and remove one from many sheets at once.
Updated 2026-07-18 -
How to Edit a Dropdown List in Smartsheet
Step-by-step: edit a Smartsheet dropdown list via Edit Column Properties, what happens to existing cell values, and how to update dropdowns across many sheets at once.
Updated 2026-07-17 -
How to Find and Remove Duplicate Rows in Smartsheet
Smartsheet has no built-in remove-duplicates button. Flag duplicate rows with a COUNTIF helper column, filter and delete them — or clear them automatically with a preview.
Updated 2026-07-17 -
Find and Replace in Smartsheet
How to use Smartsheet's built-in find and replace in a single sheet, its limits, and how to replace a value across dozens of sheets at once with a dry-run preview.
Updated 2026-07-17 -
How to Update a Smartsheet from an Excel File
Compare every way to update Smartsheet rows from an Excel file — copy-paste, re-import, Data Shuttle — and how to sync by unique ID so only changed cells are written.
Updated 2026-07-17 -
How to VLOOKUP in Smartsheet (Including Another Sheet)
How to write a VLOOKUP with a cross-sheet reference in Smartsheet, why INDEX/MATCH is sturdier, the reference limits to watch, and a formula-free alternative.
Updated 2026-07-17 -
How to Combine Multiple Sheets in Smartsheet
Three ways to combine Smartsheet sheets — copy rows, build a multi-sheet report, or merge rows into one master sheet automatically with columns matched by title.
Updated 2026-07-17 -
How to Add Images to Smartsheet Cells
Insert a picture into a Smartsheet cell with right-click → Insert Image, and how to bulk-embed dozens of images into cells at once with drag and drop.
Updated 2026-07-17