AppSheet uses cell formats to deduce the data type of each column in your spreadsheet. By applying the same format to all non-header cells in each column, you make it easier for AppSheet to determine the column's type.
In this example, the Google Sheets Format menu assigns a cell format to all cells in the Date column.
Side note: Make sure that your column headers are bolded.
