Where is the button of merge cells? Can we make some columns the same name?

LONG

Thanks for developing this app. This is a good point.

But I think we need some necessary function like excel. such as merge cells ...

And i find that i cannot name more than one columns with the same name?

When I try to import excel sheet, there even a limitation. I have to split my worksheet?

Takk

Find more posts tagged with

Manufacturing

Project Management

Comments

Kennedy Stomps

Hi LONG-- To confirm, it isn't currently possible to merge cells in Smartsheet but I can add your vote for this to our enhancement request list.

Similarly, it isn't possible to have multiple columns with the same name in one sheet, as Smartsheet requires unique column names for functions like Conditional Formatting, Reporting, and formula cell references. This is not a feature we are planning to change so I would suggest differentiating columns with numbers if needed!

We currently have some limitations on maximum sheet sizes (Up to 5,000 rows and 200 columns, in any combination that does not exceed 200,000 total cells). As a cloud-based application, there are just technical limits to the amount of information we can load and save at one time. We suggest splitting large sheets up by project or by month/year, or some other logical division. Hope this helps!

J. Craig Williams

I can't imagine that merge cells would be on the roadmap. The architecture does not seem to support features along this vein.

I could see having a section header or footer, where the column rules do not apply, but having this allowed throughout a sheet, especiallly one of any significant size would be a computational quagmire.