Welcome!

Use same column type and values on multiple columns

I have 150 columns that will have the exact same column type and values (drop down list with the exact same values). How can I apply those rules to all the columns without having to open each one individually and manually applying the formatting? Thanks

Find more posts tagged with

Comments

Mike L.

I tried to duplicate a dropdown column in a sheet but had no luck. I do have a possible solution but i hope someone else has a better one than this.

I import a lot of excel sheets into smartsheet and I find that when a column has very little variation in values that also repeat, smartsheet often automatically defines the column type as a drop down. I tested importing 5 columns of data. Each column contained 5 values that will become drop down values. I then copied the block and pasted it twice so that each value exists three times in each column.

I imported this excel sheet into smartsheet and each column imported as a drop down list with the same 5 default values.

Then all you have to do is delete the original rows if data .

Potential issue: the drop down was populated with the five values in alphabetical order (fifth,first,fourth,second,third) not the order that they appeared in the sheet (first,second,third,fourth,fifth)

Also the primary column is always going to be imported as text/number

Sign in to join the conversation!

Quick Links

Trending discussions

How to incorporate a hyperlink to a SharePoint file in Approval automation
Need help: We are using an approval request automation where we would like to incorporate a SharePoint link rather than a file attachment to the request. We have a sheet column with the hyperlink, but it does not show up in the approval email or it shows up as a LONG URL. Needs to function both from desktop computer as…
Guest User with Admin Permissions is unable to edit a Dashboard
I am the owner of a workspace that has multiple sheets and a dashboard. There are 3 Guests with Admin permissions for the whole workspace. They can edit the sheets, but not the dashboard. Is there a different type of permissions or some kind of limitations to dashboard editing for Guests?
Raffle Type System in a Smartsheet Form
I am looking at trying to build a multi-select option raffle form. Lets say a form user has 5 options or "tickets" they can put into a bucket of goods for a raffle. I would like for the user to put in any combination of entering tickets per good that they can with the five tickets they have. I will put in a picture of what…