Formatting columns
Quick guide on how to format columns (i.e. data types) in Google Sheets
Last updated
Quick guide on how to format columns (i.e. data types) in Google Sheets
Last updated
Google Sheets has two data type categories: 1) Numbers and 2) Text
To format a column in Google Sheets simply:
Highlight the column
Select "Format"
Choose the data type
In order to two-way sync fields, data types must match across your apps.
For example, if you have a Date
field in Airtable and want to two-way sync it with Google Sheets, you'll need a Date
field in Google Sheets.
Text fields will two-way sync by default. No additional formatting is needed for:
Text
Long-text
Drop-down
Multiple Select
Number fields need to be formatted in order to two-way sync:
Numbers
Percentages
Dates
Learn how to use foreign keys in Google Sheets here: