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-11-20 -
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-11-20 -
How to Download All Attachments from a Smartsheet
Smartsheet can zip the attachments you tick in one sheet. Here is that flow, what it cannot reach, and how to pull a whole workspace in one pass.
Updated 2026-11-20 -
How to Back Up a Smartsheet
Smartsheet's backup request needs Business or Enterprise and runs once a day. Here is what it includes, what an export drops, and a per-sheet alternative.
Updated 2026-11-20 -
How to Delete Blank Rows and Tidy Text in Smartsheet
Filter blank rows and delete them in one go, fix double spaces with find and replace, and tidy text across many sheets at once with a preview first.
Updated 2026-11-20 -
How to See Every Column Formula in Smartsheet
Smartsheet shows a formula one cell at a time. Here is how column formulas work, why there is no list of them, and how to inventory them across sheets.
Updated 2026-11-20 -
Why Some Rows of a Smartsheet Column Stopped Calculating
When a few rows of a Smartsheet column stop calculating, nothing flags it. Here is why cell formulas drift apart, and how to find the rows that disagree.
Updated 2026-11-20 -
How to Build a Dropdown from Another Sheet in Smartsheet
Use one Smartsheet column as the master option list: native linked dropdowns, what they require, and how to push a column of values to many sheets at once.
Updated 2026-11-20 -
How to Audit a Smartsheet Account
Smartsheet shows publishing, sharing and automation one item at a time. Here is the manual audit, and a read-only scan that covers four of them at once.
Updated 2026-11-20 -
Can You Merge Cells in Smartsheet?
The parent-row heading every answer recommends vanishes in reports. Which of the three unrelated things people mean by merging is yours, and the fix for each.
Updated 2026-11-05 -
How to See Who Has Access to a Smartsheet
The Share dialog misses workspace and group inheritance. All the paths that grant access, why the access report lags, and how to audit every sheet at once.
Updated 2026-10-31 -
Can You Change the Primary Column in Smartsheet?
You cannot re-designate it — but most of what people actually want is possible without rebuilding. Which changes work, which do not, and the safe migration path.
Updated 2026-10-31 -
How to Delete Old Sheets in Smartsheet
Deleting a sheet silently breaks reports, dashboards and formulas pointing at it. What to check first, how long recovery lasts, and how to clear many at once.
Updated 2026-10-31 -
Why Smartsheet Formulas Show #REF
What #REF, #INVALID REF and #PERMISSION ERROR mean in a Smartsheet formula, how to read a cross-sheet reference’s status in the reference manager, and how to fix it.
Updated 2026-10-15 -
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-10-04 -
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-10-04 -
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-10-04 -
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-10-04 -
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-10-04 -
How to Add Images to Smartsheet Cells
Insert a picture into a Smartsheet cell using the toolbar or cell menu, understand cell images versus attachments, and explore bulk uploading.
Updated 2026-10-04 -
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-10-04 -
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-10-04