Pasting a row into Column Titles

Matthew Krieger

I have a sheet which needs 50 or so columns. I have the column titles in cells in an excel sheet. I would like to copy/paste these into my column titles. I do not want to individually write each title or copy paste individual titles. Is it possible to do this in one action?

Andrée Starå

Hi Matthew,

Yes, but you'd need to import the excel to Smartsheet, and either use the new sheet that will have the columns from the Excel or copy/move a row to the sheet you're working on, then the missing columns would be added automatically.

Would that work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andrée Starå

Hi Matthew,

Yes, but you'd need to import the excel to Smartsheet, and either use the new sheet that will have the columns from the Excel or copy/move a row to the sheet you're working on, then the missing columns would be added automatically.

Would that work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Matthew Krieger

Saved me 1000's of clicks, thanks!

Andrée Starå

Excellent!

I'm always happy to help (to save clicks)! 😉