Choosing the Correct Cell Type

Choose a cell type based on what the value means and how people will use it. The right choice improves data entry, validation, filtering, reporting, and automation.

Common choices include:

• text for names, codes, and short descriptions
• number, currency, or percentage for measurable values
• date, time, or date-time for scheduling and reporting
• checkbox or select for controlled choices
• user cells for people and assignments
• file cells for documents and images
• Reference cells for links to independent records
• Children Records cells for objects that belong inside the record

Avoid storing structured information in a general text field when a specific cell type can express it more accurately.