Get organized quickly with Data Types
Store any kind of data anywhere you need it with over 25 data types that can be set at the column, range, and individual cell level.
Go beyond text, numbers, and formulas in cells with data types ranging from single and multi-select drop-downs, icon sets, ratings, and file attachments that live in cells.
Manage documents and images right in your sheets with the Attachment data type. Drag and drop files into Attachment cells with clickable thumbnails and fully interactive document previews.
Learn more >
Easily manage ownership and other relationships between people and data using the User data type.
Link rows between worksheets to connect data and reduce duplication, even across different workbooks, using the Related Row data type.
Learn more >
Use Related row lookup and Related row rollup data types to look up and aggregate information from related worksheets. Replace complex VLOOKUP, HLOOKUP, and XLOOKUP formulas or use both -- the choice is yours.
Color-coded options in single and multi-select drop downs make it easy to group, sort, and filter to create customized views of your data just right for your team.
Set columns, ranges, and cells to Strict to ensure data entered matches the data type of the cell.
Put any kind of data anywhere you need it by customizing the data type of any cell or range of cells.
Support for over 400 formula functions with identical syntax to Excel and Google Sheets.
Use a visual no-code workflow editor to create automations and integrations that run when a cell value changes.
Learn more >
