Hi - I had a strange frustrating issue last night. I have a Looker dashboard that uses Google Sheets as a data source. In the data source I have defined a set of formulas, fairly simple ones like IF ( ALM?="TRUE", 1,0)
A couple of days ago, the dashboard showed errors for every chart. On investigation, it was the formula fields causing the error. Every formula field had lost the field names from the formulas and now looked like IF(t.0_A_ ="TRUE", 1,0) .
I Reconnected the data source and it came back with no changes found. The sheet had data on it the whole time. No columns were changed. The only thing that's "non-standard" about the Google Sheet is that it's refreshed by AppScript every 15 minutes. AppScript wipes and loads the sheet each time, with all the columns in the same positions, header is the same etc, just the data updates.
I had to go through and redo every formula. Super frustrating!
Any ideas on how to avoid this happening in the future?
LinkedIn
Twitter
