You sum rows using a rollup column.
apologies, how would you sum columns
The rollup column does exactly that, it sums the column.
@ThinhDinh @AyS_0908 @Darren_Murphy
I have thought about the problem and want to know if the following is possible?
- 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.