Possible to create (or copy) a new column with same dropdown options from an existing?

Cristina Hanson

Hi,

This may be a very simple question and I'm just missing the answer somewhere, but is it possible copy a column with all the same attributes and drop-down choices, then I can just change the header label? I have a sheet that has numerous date columns, but the drop-down options are the same for each one. Right now the only option I see is to copy the drop-down choices from one column, create a new column, select drop-down, then paste in the exact same choices. I tried to get around it by prepopulating the choices in each column on excel then uploading that document, but all that did was give me the choices in the drop down once I uploaded it and I still had to make the choice selection and also delete the choices out of the columns. Just curious if there is a better way to accomplish this.

John Jonassen

Hi @Cristina Hanson

You have to set each column up individually, as you already are. There is no quicker option within Smartsheet.

John Jonassen

Hi @Cristina Hanson

You have to set each column up individually, as you already are. There is no quicker option within Smartsheet.