How do I add a column of data to Smartsheet?

alexandra.beddall

Hi there!

I have a request to add a column of data that was not originally included on the Smartsheet when it was created. There is an Excel master doc with the info that now needs to be included in the Smartsheet. Additionally, there is a barcode that can be used to correctly import the new info, so it matches accurately. However, I'm not sure how to go about this in Smartsheet. How do add a column with data to my Smartsheet? Thanks so much for the help!

SteyJ

https://community.smartsheet.com/discussion/110048/how-do-i-add-a-column-of-data-to-smartsheet

Hi @alexandra.beddall,

are you able to right click any column, insert column left or insert column right?

Then Name, select the data type, and copy/paste the cells from excel.

Does this work? let me know.

alexandra.beddall

Unfortunately, this is not a simple insert, copy, paste situation. The data I need to import is scrambled and needs to match the data already input in the Smartsheet. I'm looking for a solution that will allow me to import the data so that it aligns with the existing data. Is this possible? Thanks! Any help is appreciated!

Paul Newcome

Do you have access to the premium add-on Data Shuttle? If so, this should work for you.

If not, you would have to import the data into another Smartsheet then use an INDEX/MATCH type formula on the target sheet with cross sheet references to the import sheet to pull the data in. If you want it as static data once you get it in there, you can copy the data in the target sheet then "Paste Special - Values" over top of the existing column data that contains the formula.