I am losing my mind at how simple this should be.
I have a Google Sheet as my datasource.
A row is either included or excluded in further analysis according to pre-determined criteria. A column calculates this and dumps out its findings "Yes - [reason]" or "No - [reason]".
For further analysis i've created a helper column that simplifies this even further to output "Yes" or "No".
Can I get my appsheet to only include the "Yes" rows at all? No. No i can't. I've tried setting the slice to [HelperColumn] = "Yes" then applying this view in the UX but to no avail.
I don't know what the hell to do and i bet, i goddamn bet you, it's such a simple fix. Help me before I unceremoniously yeet my laptop through the window.
LinkedIn
Twitter
