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.
-
Find and Replace in Smartsheet
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.
Updated 2026-09-19 -
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 many sheets at once.
Updated 2026-09-06 -
How to Find and Remove Duplicate Rows in Smartsheet
Smartsheet has no remove-duplicates button. Flag duplicate rows with a COUNTIF helper column and delete them — or clear them automatically with a preview.
Updated 2026-09-06 -
How to Update a Smartsheet from an Excel File
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-09-06 -
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-09-06 -
How to Combine Multiple Sheets in Smartsheet
Three ways to combine Smartsheet sheets: copy rows, build a multi-sheet report, or merge them into one master sheet with columns matched by title.
Updated 2026-09-06 -
How to Add Images to Smartsheet Cells
Insert a picture into a Smartsheet cell from the toolbar or the cell menu, the size and format limits that apply, and how to bulk-embed dozens at once.
Updated 2026-09-06 -
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-09-06 -
How to Rename Columns in Smartsheet
How to rename a column in Smartsheet, why it will not break your formulas, what it means for reports, and how to rename across many sheets at once.
Updated 2026-09-06 -
Can You Change the Primary Column in Smartsheet?
Smartsheet cannot re-designate the primary column once a sheet exists. What you can change, the documented workaround for its contents, and when to rebuild.
Updated 2026-09-06 -
Can You Merge Cells in Smartsheet?
Smartsheet has no merge-cells feature. How to combine values with + or JOIN, use hierarchy instead of a merged header, and when you meant merging sheets.
Updated 2026-09-06 -
How to Unpublish a Smartsheet
How to check whether a Smartsheet is published to a public URL, switch the publication off, and find every other sheet or report of yours still live on a link.
Updated 2026-09-06 -
How to View Automation Workflows in Smartsheet
How to open the automation on a Smartsheet sheet, read a workflow, and tell a paused one from one Smartsheet switched off when the sheet changed.
Updated 2026-09-06 -
How to Delete Old Sheets in Smartsheet
How to delete or archive a Smartsheet, who is allowed to, how to recover one from Deleted Items, and what to check before you remove an old sheet.
Updated 2026-09-06