What do you do if you want to create a custom field with 100 drop down options? Unless you have the trick below, you’ll be typing everything by hand.
The trick comes from a client of ours: he imported his Excel file using the CSV importer to create all the options in a single shot.
Here’s how to do it: create a file with 2 columns, « task » and « option ». Inside the option column, write down every possible values. Inside the task column, write 1-2-3-4… or any sequence. Import the file using the CSV importer and map the option column to a new drop down field.
Voilà! How cool is that?
Only problem, and I am getting tired of this, Asana assigns random colors to each option
Edit from @LEGGO The follow up steps are 1) to edit the colors to your liking and 2) save the custom fields to your global library for use elsewhere!
Yes! I wasn’t wise enough to list this as a Forum Tip but I’ve certainly benefitted from this trick a handful of times. It’s a great approach when you are migrating a lot of information into Asana for the first time - creating multiple new custom fields on a single import.
The follow up steps are 1) to edit the colors to your liking and 2) save the custom fields to your global library for use elsewhere!
I created a tool to make it easier and avoid this hack → Create a custom field drop down from a list [tool]
What do you do if you want to create a custom field with 100 drop down options? Unless you have the trick below, you’ll be typing everything by hand.
The trick comes from a client of ours: he imported his Excel file using the CSV importer to create all the options in a single shot.
Here’s how to do it: create a file with 2 columns, « task » and « option ». Inside the option column, write down every possible values. Inside the task column, write 1-2-3-4… or any sequence. Import the file using the CSV importer and map the option column to a new drop down field.
