A user of Amplitude Sync to Drive and Sheets
December 11, 2019
Reporting bug: When adding a dashboard for the first time, the values are in number format. However when refreshing, the values now append a single quote. Additional refreshing results in single quote append. Clear all, then add report, results in no single quote. Refreshing appends single quote again. This is important because now number formats turn into text format.
Current workaround is to create another sheet that links to Amplitude sheet. 'NewSheet'!A1 can be set = "=value('Amplitude [DO NOT EDIT]'!A1). This formula can be set for all cells that require values.