Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Importing Excel sheet clarifications
I've been importing an Excel sheet for a while now.
Formerly, I didn't care about the Primary column because I was just using the sheet as temporary means to get the data to the final sheet - where column types is more important.
The first column contains a series of 1's and 0's.
In the final sheet, that is a check-box column and works great.
Now I added another column to the left and imported that.
Now the column with 1's and 0's changes to a drop-down list which when copied to the final sheet are all blank check-boxes.
There are other column with a limited set of choices but those are not drop-downs.
To the clarifications needed (http://help.smartsheet.com//customer/portal/articles/504553)
1. There appears to be no way to force the column type on import. Correct?
2. What is the logic necessary to have a column changed to a drop-down on import? 2 entries? 5?
12 seems to be too many but I'm not going to spend time investigating.
Thanks
Crig
Comments
-
Hi Craig-- This is a good question, sorry for not responding sooner. I've pinged our QA team about this, as they'll be the most likely to know. I'll let you know what I hear back from them!
