Spreadsheet.com goes beyond text and numbers with support for over 25 rich data types. Setting data types for ranges of cells allows you to customize unique cells in your worksheet. For instance, in the "Error Location" column of your team's bug tracking worksheet, you might enable some users to type where (in the mobile app) an error occurred, rather than require them to submit a URL (as they might for a bug with the web app).
How to Change the Data Type for a Range of Cells
To change the data type of a range of cells, select the range you'd like to change, right-click on that range, and select Edit data type... An Edit data type dialog box will appear for those cells. In this dialog box, you can set the Data Type and see the corresponding settings for each data type.
For instance, in the animation above, we decide that we want to record the time and date of particular calls, not just the date. We select the corresponding range of cells and change their data type from Date to Date & time.
Different data types will have different possible settings, though all data types (except Automatic) allow you to restrict the data in that range to only data of that data type. For instance, restricting an Attachment range prevents users from typing text in addition to adding files.
Once complete, click Update to change the range data type.
Changing a Cell in a Strict Range
Cells that are already part of a range of Strict cells can still be changed. However, a warning like the following will appear:
To continue, click Ok, and the Edit data type dialog box will appear.
Changing Strict Columns
Users cannot change cells in Strict columns without first changing the column's data validation. If you try to change the data type of cells in a Strict Column, you will get an error message like the following:
To edit these cells, you will need to update the corresponding column (in the error message above, this is column D) and turn off the Strict restriction.
Changing Cells in the Primary Column
Cells in the Primary Column are restricted to alphanumeric data types. If you try to change these cells, you will see fewer data type options.
Converting Between Data Types
When changing data types, users can convert existing data to a new data type. Please see our article on Converting Between Data Types for more insight into how data of one type converts to another.
Like most other changes in Spreadsheet.com, you can undo a change in data type. To undo, either select Undo in the toolbar or type Ctrl + Z (CMD + Z for Mac users). Undoing edits to a range of cell's data type will restore the range to its previous data type.
Converting from one data type to another often results in changes to the underlying data. Check out our article on converting between data types for more insight, or check out all of the 25+ possible data types you can utilize in our Data Type articles.