How to Delete Blank Rows and Tidy Text in Smartsheet

Updated 2026-11-20

Blank rows inflate counts and rollups, and stray spaces quietly break grouping, lookups and dropdown matching — "Acme " and "Acme" are two different clients to a formula. Neither has a one-click fix in Smartsheet, but both have a decent manual route. Here they are, and where they stop scaling.

Delete blank rows with a filter

Rows to delete are rarely next to each other, which is the whole difficulty: Smartsheet's own advice for deleting non-consecutive rows is to filter the sheet first, then delete what is displayed.

  1. Open Filter and create a filter with the condition is blank on the column that should never be empty.
  2. Check what the filtered view shows — it should be only the rows you intend to lose, not rows that are merely missing one field.
  3. Select the displayed rows, right-click and delete them.
  4. Remove the filter to bring the rest of the sheet back.

Fix stray and doubled spaces

Smartsheet has no documented TRIM function, so there is no formula equivalent of Excel's. What there is: find and replace (Ctrl+F, then Replace) will turn two spaces into one across a sheet, repeated until it reports no matches, and SUBSTITUTE in a helper column can strip a specific character pattern out of a value.

Both have the same shape of problem. Find and replace works in Grid View only, skips hidden columns and filtered rows, and will not touch formula cells, symbols, hyperlinks or inbound cell links. A helper column leaves you with a second column to copy back over the first and then delete. And a leading space — the kind that comes from a paste — is not something either approach catches cleanly without knowing exactly what to look for.

Tidy many sheets in one previewed pass

Our cleanup tool does the four jobs together across every sheet you select: trim leading and trailing spaces, collapse runs of spaces into one, normalise case (upper, lower or title case), and delete rows that are genuinely blank. Each run starts as a preview, and you can scope it to named columns or let it clean every eligible text column.

What it will not touch is the point. It edits only editable text cells — Text/Number and dropdown columns holding a string — so formulas, hyperlinks, images and numbers are left alone. A row counts as blank only when every cell is empty and it carries no attachments and no comments, and a blank row whose deletion would take meaningful child rows with it is refused rather than cascaded. Title case is deliberately conservative too: it capitalises word-initial letters only, so "don't" does not become "Don'T" in a write you cannot undo.

Official Smartsheet documentation: Create a filter, Insert or delete rows, Find and replace.

Do it in one pass instead

Trim whitespace, collapse extra spaces and delete blank rows across many Smartsheets at once, with a preview before anything is written.

Try Clean Up Sheets Free

Frequently asked questions

How do I delete all blank rows in Smartsheet at once?

There is no built-in button. Filter the sheet on an is-blank condition, check the result, then delete the displayed rows — Smartsheet's own guidance for deleting non-consecutive rows is to filter first. A bulk cleanup tool can do it across several sheets, deleting only rows where every cell is empty.

Does Smartsheet have a TRIM function?

Smartsheet's function reference has no documented TRIM. For doubled spaces, find and replace (Ctrl+F → Replace) will collapse two spaces into one across a sheet; SUBSTITUTE can remove a known pattern in a helper column. Trimming leading and trailing spaces in place needs a bulk tool.

Will deleting blank rows affect rows that have a formula or an attachment?

It should not, and our tool treats both as meaningful: a row is only blank when no cell holds a value, formula, image or hyperlink and the row has no attachments or comments. Deleting a blank parent row whose children still hold data is refused rather than cascaded.