I am working on an Activity Tracker through Google Forms where people will be able to track the number of minutes/hours they've been active in a particular day/week/month.
As people track their minutes of activity, I want Google Sheets to keep a running total of similarly-named columns and group this by the person's name. Preferably I'd like to also sort by the total number of hours followed by the total number of minutes, but at this point I'm not greedy. I stumbled across Google Query about an hour ago and thought it might be the best solution. With the (admittedly clumsy) query I made in the Totals sheet, I can get the column names to 'add' and the Superhero IDs to appear. Nothing else shows up. Here's my clumsy query: =query(ActivityTracker, "SELECT B, sum(F)+sum(J)+sum(N), sum(G)+sum(K)+sum(O), sum(D)+sum(H)+sum(L)+sum(P)+sum(R), sum(E)+sum(I)+sum(M)+sum(Q)+sum(S) GROUP BY B",1) and a link to my spreadsheet: https://docs.google.com/spreadsheets/d/1vi1AplKWg62tl3zjRayAVZ-VtaVH9R_jP9u4ik_kMeE/edit?usp=sharing Thanks for any assistance. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/3255f5cc-98d7-4d42-81de-89af6853f910%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
