In Spreadsheet.com, columns, ranges, and individual cells go beyond the text, numbers, and formulas of traditional spreadsheets. With more than 25 rich data types, Spreadsheet.com allows you transform a static grid of data into a collaborative application for projects big and small.
In Spreadsheet.com, Columns behave just like columns in traditional spreadsheets. You can freeze columns, copy columns, move columns, delete columns, insert columns, and more. But in Spreadsheet.com columns also have data types with data type-specific settings, and an explicit column name. Naming a column will change what appears in the column header and any place the column is referenced (like in an expanded row or in related row cells).
The Primary Column
Each worksheet contains a primary column shown with a key icon in the column header. Cell values in the primary column are used as display names for rows. So pick the column you most want to designate your rows. For instance, in the worksheet below, we have set column A, "Name" as the primary column and, when expanded, we can see that the display name for row six matches the entry in A6.
Spreadsheet.com uses display names for rows in multiple places, such as related row cells and row cards, Kanban cards, and more. Any column can be the primary column, but there can be only one primary column per worksheet.
To set a column as the primary column, right-click on the desired primary column and select Set as primary column . See our article on the primary column for more details.
Column-level data types
Setting column data types allows you to customize the data and data formatting in each column of your worksheet, plus enables unique features for each data type. For instance, setting a column of phone numbers to the Phone data type opens your default phone app so you can call numbers directly from your spreadsheet. Setting a column to the Select data type enables users to select from a list of drop-down options to enter into each cell of that column. See our quick start guide on data types for more information or visit the relevant article for that data type in our set of data type articles.
In the animation below, we set a column to the Email data type by right-clicking on the column and selecting Edit data type. After we do this, the email addresses in that column all convert to clickable formatted values.
Generally, you can override column-level data types at the cell or range of cells level. However, one unique advantage of column-level data types is the ability to sort and filter your data using data type-specific criteria.
In addition, you can validate or restrict data in your columns with the Strict setting. Columns set to strict only allow users to input data of that data type, and cannot be overridden at the cell or range of cells level.
In Spreadsheet.com, cells operate as you have come to expect from other spreadsheet software. With custom formatting, merging, and more, each cell is ideally suited for pieces of data or a formula. But, with Spreadsheet.com's data types, you can go much further. Cells can serve as drop-down select lists, ratings for users to score, allow you to assign and work with users in your project plan, or can hold attachments for documents and images associated with each row.
In the animation below, we see all of these in action; we change data in a select list, rating a candidate, tag a users, view an attachment, and even check click a related row lookup to check a job posting from another workbook.
Cell Data Types
In Spreadsheet.com, there are over 25 different data-types that can be applied to cells. In addition to the attachment, user, select, and related row data types mentioned above, there are data types for text, numbers, percentages, dates, email addresses, icon sets, and more.
You may wish to set a cell level data type if you have a one-off cell that is different from the rest, or different from the data type of the column. For instance, cells in your header rows may have completely different data types compared to those in the same column as your table region.
To set a cell's data type, simply select the desired cell, right-click and select Edit data type .
In addition to workbook-level messages, you can add a message to a particular cell (akin to commenting) or even @mention a user to call attention to something.
Cells with messages in them will show a yellow message indicator in the top right corner.
You can add or view cell messages by right-clicking on the cell and selecting Cell messages, or by expanding the row.
Like columns and cells, ranges in Spreadsheet.com behave similar to ranges in traditional spreadsheets. You can select and reformat ranges by holding the left mouse button and dragging your cursor across the desired cells.
Similarly, you can use the drag handle at the lower right of a selected cell to copy that cell's data or formula and apply it to other cells. For instance, in the animation below, we added some new referrals to our applicant tracker, so we set one cell as "New Referral" and dragged that cell down to autofill a range of cells below it.
Range-level Data Types
Like with columns and cells, you can apply over 25 different data types to a range of cells. Simply select the desired range of cells, right-click, and select Edit data type .
Range and cell-level data type settings can override column data type settings only when a column is not set to Strict.