You sum rows using a rollup column.
apologies, how would you sum columns
The rollup column does exactly that, it sums the column.
- Force users to use emails to use the app (thus having a way to get a user specific id)
- Have glide push down a specific users scores to the google sheet (maybe a column for each users’ scores)
- Use lookups/array formulas in google sheets to do user specific calculations
- Return user specific results to the app interface
What you describe there can be done, and should work. However, I would encourage you to persist with keeping the calculations within Glide, as it will make for a much better user experience. From what I’ve seen in the videos that you’ve shared, I believe it’s perfectly doable, but it probably involves using a few Glide techniques that you might not be familiar with (yet). I don’t have time now to go into specific details, but somebody else might chip in.