How to Find and Remove Duplicate Rows in Smartsheet
Smartsheet has no built-in "remove duplicates" button, so duplicate rows tend to pile up quietly and inflate counts, reports and rollups. The standard manual fix is a helper column with a COUNTIF formula; here is how to set it up, where it gets tedious, and the automatic alternative.
Flag duplicates with a COUNTIF helper column
Add a new column (call it "Duplicate?") and use COUNTIF to count how often each row's key value appears in its column. For a sheet keyed on an Order ID column:
- Insert a helper column next to your data.
- In its first cell enter:
=IF([Order ID]@row = "", "", IF(COUNTIF([Order ID]:[Order ID], [Order ID]@row) > 1, "Duplicate", "Unique")) - Drag-fill the formula down the column (or convert it to a column formula so new rows inherit it).
- Create a filter where the helper column equals "Duplicate" to see every duplicated row together.
- Review the filtered rows and delete the copies you don't want to keep.
Where the manual method gets painful
The formula flags every copy — including the one you want to keep — so you still have to eyeball each group and decide which row survives before deleting the rest by hand.
For a match defined by several columns, prefer COUNTIFS with a criterion for each field. Simple concatenation can collide: values AB + C and A + BC both produce ABC. If you use a combined key, use an unambiguous encoding. Keep the helper as a column formula for ongoing detection or remove it after a one-off cleanup. The leading blank check skips rows without an Order ID.
Remove duplicates automatically
Our Deduplicate tool does the whole loop in one pass: you pick the sheet and the columns that define a match, it finds the duplicate rows, keeps the first occurrence (or the last, if you prefer), and shows you exactly which rows would be deleted before anything is removed. Rows whose key columns are all blank are skipped rather than flagged as copies of each other — the COUNTIF trap above. It works one sheet at a time. No helper columns, no formulas, and it is just as fast the tenth time as the first.
Official Smartsheet documentation: COUNTIF.
Do it in one pass instead
Find and delete duplicate rows in a Smartsheet automatically, matched on the columns you choose, with a preview before anything is removed.
Try Deduplicate FreeFrequently asked questions
Does Smartsheet have a built-in remove-duplicates feature?
No. The grid has no native dedupe button — the common workaround is a helper column with a COUNTIF formula, followed by filtering and deleting rows by hand, or using a bulk tool that automates the pass.
How do I find duplicates across multiple columns?
Use COUNTIFS to compare each key column separately, or choose the matching columns in a dedupe tool. Avoid simply concatenating values without an unambiguous encoding, because different field combinations can produce the same key.
How do I keep one copy and delete the rest?
A COUNTIF helper flags every copy including the original, so manually you must pick survivors yourself. The Deduplicate tool keeps the first occurrence of each group automatically — or the last, if you choose — and previews exactly which rows will be removed.