What can we help you with?

How to Change a Column Type

Have you ever wanted to keep all of the data in your column but change the type of column? Keep reading to learn how to change the type of column on your board without having to delete it and start from scratch! 🎉🎉

How does it work?

There are a few different available transformations for your columns. When you choose to transform one column into another type, your data is translated and reformatted to suit the new column type! For example, transforming a Dropdown Column into a Status Column will turn each of your drop-down items into status labels! 

Let's take a look at an example! We have a Rating Column on our board and we want to turn it into a Numbers Column. To do so, we'll click the arrow to the right of the column's title, and click "Change Column Type". Now, we'll be given a list of column options that the column we've selected can be transformed into. In this case, we'll choose "Numbers". 

image_1.png

This action will create an additional column with the same values as the original column. A pop-up window will ask you if you'd like to "Go back" to keep the original column, or if you'd like to "Keep changes". 

image_2.png

If you choose to keep the changes, your original column will be deleted and replaced with the new selected column! In this case, all of our ratings (hearts out of 5) have been changed to a number from 0-5. If you choose to go back, your new column will be deleted and your original column will be restored just the way it was!

 

captured__8_.gif

 

Note:  If you regret your decision to change your column type later, you can always retrieve your deleted column from the Recycle Bin

 

Which columns can be changed?

Any of your columns can be changed to either a Text, Long Text, or Numbers Column

 

Some other transformations include:

  • Date Column -> Timeline Column 
  • Tags Column -> Status Column
  • Numbers Column -> Status Column
  • Text Column -> Email Column
  • Text Column -> Date Column
  • Text Column - > Tags Column
  • Dropdown Column -> Tags Column
  • Dropdown Column -> Status Column

 

If you have any further questions, please don't hesitate to reach out to us by sending us an email to [email protected]