Blog

There are several various column transformations available. When you transform a column into a different type, the data is translated and reformatted to accommodate the new column type! By converting a Dropdown Column to a Status Column, for instance, each of your dropdown options will become status indicators!

Let’s look at an illustration! We wish to convert the Rating Column on our board into a Numbers Column. To accomplish this, we will click the arrow to the right of the column’s title and select “Change Column Type.” Now, we will be presented with a list of column options into which the selected column can be transformed. In the current situation, we will choose “Numbers.”

This action will create a new column containing the same values as the original column. A pop-up window will question whether you want to “Go back” to retain the original column or “Keep changes.”

If you choose to retain the modifications, the original column will be deleted and replaced with the new column! All of our evaluations (hearts out of 5) have been converted to numbers between 0 and 5. If you choose to cancel, your new column will be removed, and your original column will be restored to its previous state.

Note:  If you change your mind about changing the column type, you can always retrieve the column from the Recycle Bin.! 

 

Which columns can be changed?

You can transform any column into a Text, Long Text, or Numbers column!

A few additional transformations involve the following:

• 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 Colum