So currently i do a cfb pickem league where every week each person picks 5 games. At the end of the week i update if the person got them right or wrong and it all goes into one spread sheet i have on google sheets. well now every time someone submits there answers it is using one of my updates and i only get 500 a month. problem is i have about 100+ people submiting their 5 games every week so that is going to get used up pretty fast. I want to move it to a glide table i guess (not by choice) but on the app i built i query the spread sheet that has the history of each users picks to show for the year how many they got right and wrong. What their past picks were and a bunch of other data. So my question is is there a way that i can do the same thing somehow if i use a glide table and just pull all the data for a specific user to display differt things. i Use the query Select Sum funtion and i dont know if glide table can do that.
Have a look at the Glide Query column. I suspect you could use that and then a series of rollup columns to get what you want.
2 Likes