Importing Excel Sheets with columns that have a Menu Selection

Rick Girard

I have an excel sheet with imbedded menu options (Yes, No...etc multiple types of selections) in several columns, is there a way to import those menu items. I am only getting the basic cells, there are no formulas to import but critical that I get all these multiple menu items pulled in.

Please advise and thanks.

Genevieve P.

Hi @Rick Girard

There currently isn't a way for Smartsheet to read the Data Validation source values for a column in Excel and apply that to the column properties of a Dropdown column in Smartsheet.

After you have imported your Excel file, you can adjust the column in Smartsheet to be a Dropdown column type instead of Text/Number. This will automatically bring in the current cell values as Dropdown values (that you can adjust as needed). See: Maintain consistency in data collection with dropdown columns

Cheers,

Genevieve

Rick Girard

I will try it out, thank you.