Quinntastic
Well-known member
- Location
- United Kingdom
Is anyone who is good at google sheets willing to help me?
what would u need to be done? ( I know a bit my way around with sheets)Is anyone who is good at google sheets willing to help me?
I smell a looming school project?I'm not sure how to word it. But on google sheets, I have made a nomination of the month. I want it to link to my spreadsheet and display the data nicely. with a drop-down menu where I can change the month. And a pie chart appears with whose been nominated. Then below that, I want all of the submissions from that month. I have a basic one, but it doesn't work very well. The very high-quality drawing is what I want it to be like.
I have some form of what I would like, but it's missing a lot and it doesn't work very well.
View attachment 12723
View attachment 12725
View attachment 12726
Haha. nope. Not a school projectI smell a looming school project?
Thank you, that is perfect. Do you know how I can create validation? So for example, if someone inputs "quinntastic" and someone else inputs "Quinntastic" how can I get those two inputs to stack as one?Basic example sheet that does as you have requested, can change and format as you like just copy it.
You'll just have to make a form and link it to this sheet then adjust the formulas to the new form raw output.
https://docs.google.com/spreadsheets/d/1Uvin9EMmaXen7RFf0P1Lz24TqJQbw7HN-_X_I3WCm9E/edit?usp=sharing
The count function doesn't take into account case however the unique does so the basic creation above will deal with those in odd ways.Do you know how I can create validation? So for example, if someone inputs "quinntastic" and someone else inputs "Quinntastic" how can I get those two inputs to stack as one?
I would but there's close to 90.The count function doesn't take into account case however the unique does so the basic creation above will deal with those in odd ways.
To fix this adjust that code to =SORT(UNIQUE(PROPER(B13:B))) This has been adjusted in the provided sheet.
An easy way to validate info would be if you have a set list of possible nominees then just create a dropdown list within the google form so you only get those inputs.
We use essential cookies to make this site work, and optional cookies to enhance your experience.