Quick summary
Smartsheet does not support traditional cell merging, but you can combine cell data using a formula in Grid View and then center-align the result for a clean, consolidated display. This step-by-step walkthrough shows exactly how to build the formula, run it, and apply center alignment in Smartsheet.
Steps
- In Smartsheet's Grid View, select the destination cell where you want to merge data and type an Equals (=) sign to start your formula.
- Select the first cell whose data you want to include in the merged result.
- Return to your formula bar and type a Plus (+) sign to continue building the formula.
- Select the second cell whose data you want to combine with the first.
- Review your completed formula, then press Enter or Command to run it and display the merged data.
- Resize the column containing the merged data by dragging its column header divider to fit the combined content.
- Navigate to the top menu bar and click Align Cell Content.
- Select Center from the alignment options to horizontally center the merged cell content.
- The data from your selected cells is now merged and centered in the destination cell.
