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.

 

Did this answer your question?