Importing large file from Excel into Smartsheets

Paul Newcome

You would have to create a new sheet for each tab if the volume is as high as you say it is. From there you can recreate your VLOOKUPs, INDEX/MATCHes, and any other formulas you may have had in there that don't follow the same syntax as Smartsheet.

TEATom

I went ahead and imported each tab but still waiting for my employer to potentially get Data shuttle and Data Table access. That said, since there are many vlookups as well as other formulas in the original Excel, it appears as though I am now going to have to figure out the correct 'function' as SS refers to it, that will correspond to the formula in Excel. For one, I am trying to figure out how to get SS to combine two cells with an "-" between the two like this: =[Refunded Bond #]1&"-"&[Refunding Bond #]1

Any thoughts?

Paul Newcome

@TEATom Concatenation in Smartsheet is simply "adding" each piece of the string together.

=[Refunded Bond #]@row + "-" + [Refunding Bond #]@row