Why Internal Dashboards Are Ignored After Six Months
Why internal dashboards get abandoned after a few months, from data trust to speed and decision ownership.
All tags Tags
#Data
3 posts
Sheets Turns Your Text Into a Date: When '2026-06' Blocks Completion Forever
Google Sheets silently coerces strings like '2026-06' into a Date. When save, read, and compare each compute the month differently, completion is rejected forever. What gets coerced, how to pin cells to text and guard on read, plus batch writes and formula injection.
PropertiesService Is Not a Database: the 9KB Wall
A Properties value caps near 9KB. Cache only data you can lose. Big state goes to Sheet, Drive, or an external DB. Plain JSON loses types.