merge cells.

Eberto Pallares

Is there any way to merge cells in Smartsheet? this is critical to me and the JOIN formula is not the easiest way to address this like excel.

Thanks,

Eberto.

Dale Murphy

@Eberto Pallares By "merge" do you mean putting the content of two (or more) columns into another column?

Very simplistic approach (which I use regularly) is [column 1]@row + " and " + [column 2]@row + ...

The result from the above is two strings with the word "and" between them. You can string together as many columns or static strings as you need.

It can also be turned into a column formula.

Is that enough?

Dale

Eberto Pallares

I want to be able to display all information across the cells...if you see here only c/9860 Building construction Project

Eberto Pallares

like in excel

Dale Murphy

@Eberto Pallares

Nope, no way I know to do that within a sheet. IMO sheets are not the best vehicle for presentation purposes.

Dale

Eberto Pallares

Sad :) this should be a "basic" functionality of this platform.

Ken Walker

The only way I've been able to do it is changing the cell color for all columns that related. I would suggest pale colors, so if you have conditional formatting configured in specific cells, you could use bold colors to have them stand out in the sheet. Hope this helps.