How do I add a column of data to Smartsheet?
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!
Answers
-
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.
Sincerely,
Jacob Stey
-
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!
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 443 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives