How to Merge Data From Multiple Cells in Smartsheet
- George Apostolov
How to Merge Data From Multiple Cells in Smartsheet: step-by-step guide
Inside Smartsheet's Grid View, select a cell and type an 'Equals' (=) sign to enter a formula.
After that, tap the first cell that contains the data you want to combine.
Go back to the cell with the formula and add a 'Plus' (+) sign.
Subsequently, tap the other cell you want to merge.
Review the formula, then press the 'Enter' or 'Return' key to run it.
After completing these steps, the data from the selected cells will be merged into one cell.
Quick answer: To combine cell data in Smartsheet, enter an equals sign in a grid view cell to start a formula, tap the first cell, add a plus sign, select the second cell, and press Enter to run the formula and merge the data.
About this Smartsheet tutorial
Merge data from multiple cells into one using a simple formula in Smartsheet grid view. This guide shows how to merge Data From Multiple Cells in Smartsheet in 6 steps, starting with "Inside Smartsheet's Grid View, select a cell and type an 'Equals' (=) sign to enter a f..." and finishing with "After completing these steps, the data from the selected cells will be merged into one...". The interactive demo above is a click-through copy of the real Smartsheet interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to merge Data From Multiple Cells in Smartsheet?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Smartsheet data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Smartsheet. Related guides: How to Publish a Smartsheet Document, How to Search in Smartsheet and How to Sort Rows in Smartsheet. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
