Change the type of your columns as date/boolean/number etc

Utilize understands the column type based on the majority values in a column. If you want to convert the column into a different type, please see the steps below.

Let's say you have to change the type of the column to Date.

1. Go to your Google Sheet and add a Date value to it (for eg, 23 Jun 2022). If you'd want the column to have time as well, add a Date Time value instead (for eg, 23 Jun 2022 13:00:00)

2. Come back to Utilize's app builder and click on Reload Sheet. Reloading helps understand any structural changes made to the sheet.

You can do similar actions for any of your columns by adding relevant values to them and reloading the sheet.