“SELECT formula on DashboardFilters table returns empty from within a TASKS slice, even with TRUE as condition. Data exists in the sheet. Table is on separate tab of same Google Sheet.”
Please post screenshots of the involved configuration,.
Check out the sample app from this video
- Pay close attention to the slice filter conditions.
The best way I’ve found to debug things like this is to reduce your slice filter formula to a single criteria, make sure that one works; then add in another, then another, etc. - one at a time, this way you can single out the part that’s actually causing the problem.