Possible to create (or copy) a new column with same dropdown options from an existing?
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.
Help Article Resources
Check out the Formula Handbook template!