I use formulas in Google Sheets to dynamically generate all the dates I need to use for my queries, and I want to reference those cells instead of hard coding the dates or using SM's template date ranges (screenshot).
I'm running into two issues:
1) If I click inside the date field the date picker obfuscates the view of the cell. I have to copy and paste the formula in because I can't see inside the field once I click on it (screenshot)
So =Dates!B16, for example, turns into %RANGE:'Solutions Landing Pages'!Dates!B16% and trashes my entire document.
But the documentation on your site is woefully lacking in what this reference should look like (screenshot). And, though your site references this document, there is 0 guidance on how to use it. For example, when you click inside one of the date fields, you see this, but the example you share ("first day of last month") is nowhere in that help doc.
What I'm trying to pull in are two dynamic dates:
Is this issue still topical or was the fix my colleague sent you via Twitter sufficient?