Can You Merge Cells in Smartsheet?

Updated 2026-11-05

The workaround every answer hands you — indent the rows under a parent row and let the parent act as the merged header — quietly stops working the moment somebody reads that data as a report. Smartsheet documents it plainly: reports do not display row hierarchies from the source sheet. The grouping you just built exists in the sheet and nowhere else, and nothing warns you. There is a documented way to carry it through, and it is a formula rather than a setting.

Which fix you want depends on which of three unrelated jobs brought you here: showing two values in one cell, putting one heading over a group of rows, or consolidating several sheets. They share nothing but the word merge. On cells the strict answer is no — there is no merge-cells command, no equivalent of Excel's "Merge & Center", and no setting that makes one cell span two columns or two rows — but each of the three jobs has a real answer below, and choosing the wrong one is what costs you later.

Combine two cell values into one

If what you want is "First Name" and "Last Name" showing up together in a single cell, that is concatenation, not merging — and Smartsheet does it with a formula. The plus operator joins values, and quoted text inserts literal characters between them:

  1. Add a column to hold the combined value.
  2. In its first cell, join the two columns with +: =[First Name]@row + " " + [Last Name]@row
  3. The quoted " " is what puts a space between them. Swap it for "-" or ", " for a different separator, or drop it entirely to run the values together.
  4. Convert it to a column formula so new rows inherit it automatically, rather than drag-filling every time.

Combine a whole range with JOIN

For more than two cells, + gets unwieldy. The JOIN function takes a range and an optional delimiter instead:

JOIN(range, [delimiter]) — Smartsheet's own example, =JOIN([Clothing Item]1:[Item Number]1, ": "), joins two columns of row 1 and returns T-Shirt: C001.

The delimiter is optional; leave it out and the values run together with nothing between them. That example runs across a row, which is the usual case when you are collapsing several fields into one label — but a range down a column, [Clothing Item]1:[Clothing Item]3, works the same way.

What to do instead of a merged header cell

If you wanted a merged cell for layout — one label sitting above a group of rows — the Smartsheet answer is hierarchy rather than merging. Indent the rows underneath a parent row, and the parent acts as the group heading. It collapses and expands in the sheet, and unlike a merged cell it does not fight with sorting or filtering.

The catch is reports, and it is the reason this workaround disappoints people weeks later. Smartsheet's own guidance is that reports do not display row hierarchies from the source sheet, so a parent row arrives in the report as an ordinary flat row and the grouping is simply gone. If anyone downstream reads this data as a report rather than opening the sheet, the parent-row heading is not enough on its own.

The documented way through is the ANCESTORS function, which turns the hierarchy into a value a report can display. It cannot stand alone — it has to be the range argument of another function — so pair it with JOIN or INDEX in a helper column. Smartsheet's own example, =JOIN(ANCESTORS(Description@row), " - "), returns Formal Dress Shirt - Assembly - Add Buttons for a row three levels deep. Add that column to the report and every row carries its own heading with it.

And where the real problem is simply that a long value looks cut off, that is a display setting, not a structural one: widen the column or turn on text wrapping and the whole value shows without any merging involved.

Why merged cells do not exist here

This also fits how Smartsheet works — it is row-oriented: every row is a record, and features like reports, forms, automations, update requests and cross-sheet references all assume one value per column per row. A merged cell breaks that assumption, which is why the workarounds above are structural (a formula, a parent row) rather than cosmetic.

If you meant merging sheets, not cells

If you meant combining sheets, our consolidation guide compares manual copying, native copy automation, reports and a bulk merge. Our Merge Sheets tool appends selected rows into a target, matching columns by title, with a preview before writing.

Official Smartsheet documentation: JOIN syntax and examples, ANCESTORS syntax and examples, reports and their source sheets.

Did you mean combining whole sheets?

Combine rows from many Smartsheets into one master sheet, matched by column title, with optional source tagging and duplicate skipping.

Try Merge Sheets Free

Frequently asked questions

Can you merge cells in Smartsheet?

No. Smartsheet has no merge-cells feature and no equivalent of Excel's Merge & Center — a cell cannot be made to span multiple columns or rows. To show two values together in one cell, join them with a formula instead; to create a heading over a group of rows, use an indented parent row.

How do I combine two columns into one cell in Smartsheet?

Use a formula. The plus operator joins values and quoted text adds separators, so =[First Name]@row + " " + [Last Name]@row produces "Jane Smith". For more than two cells, JOIN(range, [delimiter]) does the same across a whole range.

What is the difference between merging cells and merging sheets in Smartsheet?

They are unrelated. Merging cells means combining adjacent cells into one, which Smartsheet does not support. Merging sheets means consolidating rows from several sheets into a single master sheet, which is a normal Smartsheet workflow you can do by copying rows, building a multi-sheet report, or using a bulk merge tool.