The date range functionality for our Google Sheets integration is set up to accept a wide range of date formats.
As long as you're using one of the date formats below, your widgets will change based on the date range you've set in our platform.
Acceptable numerical date formats
For example: "26-04-2019" for April 26th, 2019
For example: "26/04/2019" for April 26th, 2019
For example: "04/26/2019" for April 26th, 2019
For example: "04-2019" for April, 2019
For example: "04/2019" for April, 2019
Acceptable written date formats
Written month, day, year
For example: "July 1st, 2019" or "July 1, 2019"
Written month, year
For example: "December, 2019"
Configuring Google Sheets cells as a "date" format
We recommend setting your Google Sheets cells as "date" format to ensure date range compatibility. If you're getting an invalid date format on your widget, please format your date column by selecting the column > Format > Number > Date.