Using AppSheet, I have found it really helpful to first create a sheet in Tiller that pulls or produces the Tiller-housed data you want to see on your mobile device. Then reference the customized sheet in AppSheet.
This eliminates much the hidden complexities of formatting and formulas, but focuses on top-line results these produce. It offers great opportunities to create the custom solution you’re looking for.
For example, on my AppSheet solution, I wanted to be able to see my account balances. So I created an additional sheet in Tiller called, Mobile Balances. This sheet produces a simple roster of the current results that the Tiller Magic is producing behind the scenes on the Balances sheet: the account names, the date last updated, and the balances, using cell formulas like this: =Balances!B11, and so on.
In AppSheet, I pull the Mobile Balances sheet…works!
Does that help?