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 Text Excel Data as Drop List
Hi all -
I imported data from a spreadsheet, and some data columns that had been text in Excel became drop lists in Smartsheet. So, for example, I had a column 'Frequency' which had 6 different values such as 'Calendar Annual', and Smartsheet created a drop list with those values. But other columns, such as 'Benchmark' with many more values, such as 'S&P 500', were not converted to a drop list. I'd love it if they would - is there any way to set that as a conversion rule for particular columns' data?
Thanks in advance.
Comments
-
If you right-click on the Column header and choose: Edit Column Properties and choose Dropdown, it will convert the column to a dropdown and include all current field answers as possible choices. You can then choose other options thereafter.
