How do I convert a dropdown column to a status column?

Is there a way to do this? It seems like there must be…

I have several dropdown columns with 10+ options that I want to convert to Status columns so that I can import more items. (Monday.com doesn’t allow Dropdown column imports). Then I’ll need to re-convert to the status column back to being a dropdown column…

Am I making this more difficult than it needs to be? What am I missing?

Hi @colleencass - yes, this easily done in monday - is there a reason you dont want to use a status column instead of a dropdown (so you dont have to convert). Also, if you have multiple values selected in your dropdown, the selected value will not be coverted.

All you need to do is select the option arrow on your dropdown column: Change Column Type > Status. In this example I created a dropdown with the options 1,2,3,4,5:

Once converted (which sometimes takes a few moments) you will have a new status column with your dropdown values:

Once you import your data, you can change the column back to a dropdown using the same function as above:

Hope this helps,

Thanks,
Mark

Sorry - I think I was having a brain freeze moment. I’m having a larger problem importing items with dropdown fields, and thought for some reason that converting the corresponding Monday columns to status columns before trying to import them would help me. It unfortunately does not.

Disregarding the specifics of my original post, if you have any solutions about how to solve the problem demonstrated in the attached photos, of converting a text column to a dropdown column, I’d really appreciate it!! The problem is around categories getting broken up by word, which will require a ton of manual labor to fix when I import all my contacts

Screen Shot 2021-02-25 at 4.03.40 PM|113x500

Hi @colleencass - No worries, I have about 7 brain freeze moments a day :slight_smile:

If you want to convert a text field with more than one word into a single dropdown option, the text fields should be in quotations, otherwise it will be seen as two options. In the below example I converted a text field “2 words” into a single dropdown option where the one with no quotes is converted into two:

image

This would require your text fields that have more than one word to be updated with quotes.

Is this closer to to what you were looking to accomplish?

Thanks
Mark

1 Like

Yes, this is exactly what I needed to know, THANK YOU! Now I just need to adjust in Excel, but that’s a lot less work :slight_smile: thanks!

1 Like

Excellent! Glad this is what you were looking for :slight_smile:

If you ever have questions you have come to the right place for sure.

Take care,
Mark

Hi @mark.anley - wondering if you can share some more wisdom. I haven’t had trouble with this in the past but am now! When I try to convert a column to dropdown, it’s only picking up the first item, whether I have other items in quotes or not. Any idea why this is happening?

Screen Shot 2021-04-15 at 9.48.33 AM|612x500

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.