Quick summary
In Smartsheet, you can merge data from multiple cells into one by writing a simple concatenation formula using the equals and plus signs in Grid View. This method lets teams consolidate information across columns without losing the source data.
Steps
- Inside Smartsheet's Grid View, select a cell and type an equals (=) sign to begin entering a formula.
- Tap the first cell that contains the data you want to combine.
- Go back to the formula cell and add a plus (+) sign to extend the formula.
- Tap the second cell you want to merge into the formula.
- Review the formula, then press the Enter or Return key to run it.
- The data from the selected cells will now be merged into one cell as a combined result.
