One advanced way to use formulas is to assist in converting existing data between data types.
Some conversions require no additional steps and can be handled automatically in Spreadsheet.com, for instance converting from data of the user data type to the email data type. Other data may need to have some logic applied to it. For instance, converting from a select list to an icon set.
In such a case, you may need to specify logic for the conversion, for instance, logic on how to convert:
Using formulas to convert between data types
When creating your formula, remember that each data type requires your formula to use specific output syntax to return values in that data type. Also, you may wish to check the ways that Spreadsheet.com already converts data of different data types, as Spreadsheet.com may be able to handle your conversion for you.
If not, you can set a cell, range of cells, or column to the desired output data type and add formulas to these cells to return the correct value.
For instance, in the animation below, a previous user has rather confusingly created a column called "Chance of Failure" in our CRM worksheet. We'd like to replace this, both because it's confusing (100% chance of failure means the deal has failed) and to create a visual that we can quickly scan. So, we update our output column's data type to icon set, click on the first cell in the table, paste in a formula that converts from select to icon set (and outputs in the correct syntax), then apply that formula to the remaining rows in the table.
To see data types that can use formulas to assign values, check out our advanced formatting articles. Or see our Data Type articles for more about the various data types and what happens at conversion.