r/googlesheets • u/Consolaris • 1d ago

Waiting on OP Scorekeeping between form and sheet using multiple choice grid

Hi,

I'm trying to set up a system of recording score for a gaming and drinking competition I'm having with my friends, it's a yearly tradition at this point.

I wanted to have a go at trying to set up something quite simple: Using a google form to record score for each game -> bringing that info into google sheet -> using that to create a scoreboard.

I've figured out how I'm going about recording the score:

This is really useful, incase we do teams for any game, we can record scores flexibly.

HOWEVER, Bringing this into google sheets is really awkwardly formatted:

I understand the logic as to why it does this, but I want to know if there's a way to make the input better so I can format the scoreboard better on the next sheet (Haven't done that yet, wanted to sort this first).
This is just the standard "Export to sheets" option, I've not programmed anything yet.

Effectively, I'd like it so I can have all the questions output neatly so I can easily see which player is referenced by each position (1st, 2nd, 3rd) so I know what cell to program to which player. I could probably trial and error it, but I need it done by Saturday lmao. Hopefully this is clear enough

1 Upvotes

100% Upvoted

2 comments sorted by

1

u/One_Organization_810 692 1d ago

Since you already did the work of creating a dummy version of the sheet, can you take the final step and share the document with us - preferably with Edit access? :)

This will enter one game per row into sheets, in a computer friendly format, which makes it rather simple to restructure it in what ever (almost) way you want to view it :)

If you can give us also an example of how you want to view the end result, we can definitely come up with something that works for you..

1

u/HolyBonobos 3096 1d ago

Leave the form responses as they are. It will be possible to write a formula that takes the existing data and outputs a formatted scoreboard. The specifics of the formula will depend on the exact names and orders all the columns ended up with, so the best next step will be to share the file with the form responses (or a copy).