Hi - I am copy pasting a few rows from an excel sheet into a coda table. it changes the column type of 2 lookup columns into ‘select list’ . That’s causing me problems. any way to prevent this?
Dear @Puneet_Agarwal, welcome to the community
As far as I can understand for both instances there are multiple options in the selected cell and therefore Coda assumes that you need the “select list”.
You can convert these to a table as shown below:
After that this column becomes a lookup as shown below:
Hopefully this will work out for you, otherwise you will have to update your source doc accordingly and create the tables independendly.