merge cells

Abdel Atia

 

 

Hello everyone,

Is there any way to merge cells in Smartsheet?

 

Thank you in advance!

Brent Nathan

You can't merge them in the way you could in excel to span them across rows or columns, but you can add data from several cells into one cell using a JOIN formula.

Abdel Atia

thank you Nathan for the answer,

Can you tell me more about this formula? 

How to use it?

Thank you  

 

Shaine Greenwood

Hi Abdel,

You can find details on the JOIN function in the help center: https://help.smartsheet.com/function/join

Mike Wilday

You can also create simple joins by using a formula like this: 

=[Column Name]1 + [Another Column Name]1

*You only need brackets if your column name has spaces.

Abdel Atia

Thank you Shaine !

Abdel Atia

Thank you Mike!

Ben@HRH

Merged cell capacity is critical. Please add  - otherwise the advantage over a shares XLS / Google sheet is questionable.

Mike Wilday

Hi Bene, there is a lot of functionality that Smartsheet offers that products like Excel and Google Sheet don't. The limitations, depending on your project, pale in comparison to the benefits if using a Google sheet or excel. There are project management capabilities that are far more useful than the other spreadsheet applications offer out of the box. Be careful to look closely at the specialized solutions that Smartsheet offers. Things like reporting, Gantt charts, project management features are pretty unique to Smartsheet or much easier to complete compared to the solutions you are suggesting. 

 

susan.irby58276

While agree that there are many features that are far better than Excel, the merge capabilities is an issue with my team.  Have been able to get good adoption, across the organization but this is the one thing that drives people back to Excel or Google sheets if they want to present the data.  

 

pzol

Second that... it's a basic functionality on all spreadsheets

Michelle Vonderau

Please submit your votes for merging cells here: https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409&_ga=2.178226092.802454820.1548080163-1740343258.1514317179

The Smartsheet team is now using this form to navigate and plan feature requests. 

Michelle Vonderau

Please submit your votes for merging cells here: https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409&_ga=2.178226092.802454820.1548080163-1740343258.1514317179

The Smartsheet team is now using this form to navigate and plan feature requests.