Source file is Excel with multiple tabs. The last tab is “Results”. Results contains numerous rows with aggregate formulas such as “Days since last cleaning”, “Count of cleanings last 30 days”, etc.
calculated from data on other tabs.
The point of this tab is a sort of dashboard summarizing data.
It’s a clean sheet with only two columns. Name of metric in first column and second column a reference to other another tab with the domain functions to that do the heavy lifting.
The AppSheet data import will not pull any rows from this Results tab that contain these functions .
It will import rows with just text.
I do not need to write to this dataset, how can I just pull a static snapshot of the tab as this source?