-
• #1602
I'm guessing I need responses before I can generate the graph? Or can you set it up pre-emptively? At the moment if I create a new spreadsheet to link the responses to it's just the one blank Form Responses page and there's obviously no data to base the graph on.
-
• #1603
you can do it pre-emptively, just select the rows where the data will come on the sheet.
-
• #1604
Bah, still can't figure it out. I'll look into it at another time, I'm just getting tired and annoyed with it now!
-
• #1605
Right, that's that. Here we go...
Voting for #aroomwithaview
Rules: https://www.lfgss.com/comments/12794523/
Opening Post: https://www.lfgss.com/comments/12991685/Entries:
- @mi7rennie - The Place Where We Come To Eat - https://www.lfgss.com/comments/12993865/
- @skydancer – Chris - https://www.lfgss.com/comments/12997564/
- @Rik_Van_Looy – Breakfast Realisation - https://www.lfgss.com/comments/12997625/
- @WillMelling – No Woolfs - https://www.lfgss.com/comments/12997762/
- @marcom – Steamed View - https://www.lfgss.com/comments/12998389/
- @f1s – Barred View - https://www.lfgss.com/comments/12999078/
- @Dammit – Untitled - https://www.lfgss.com/comments/12999079/
- @c0gsucker – Untitled - https://www.lfgss.com/comments/12999123/
- @moocher – 02:16 - https://www.lfgss.com/comments/12999327/
- @IzMota – Half There - https://www.lfgss.com/comments/12999742/
- @thross – Homeward Bound - https://www.lfgss.com/comments/13000019/
- @YellowH4 – Untitled - https://www.lfgss.com/comments/13000334/
- @haveo – Sea View - https://www.lfgss.com/comments/13000558/
- @MrDrem – Taking A Break - https://www.lfgss.com/comments/13000588/
Vote: https://goo.gl/wN8i9M
Results: https://goo.gl/7DbIfiEverything should work, but please let me know if there are any problems!
- @mi7rennie - The Place Where We Come To Eat - https://www.lfgss.com/comments/12993865/
-
• #1606
Looking at https://goo.gl/8oSxOC
I find it a bit tricky to explain, but it's driven by the countif on Column B of Sheet2 which requires Column A to match with column C of 'Form responses 1' which is what you put into the google form as an answer.
(the above is a bit of a shit explanation, anyone else look at it, and put it better?) -
• #1609
Wow! I'm not going to lie, I'm pretty excited to have won! Thank you for the votes.
This week's theme is 'neatness in nature'. My absolute favourite subject to photograph.Go well.
-
• #1610
Congratulations, Yellow (voted for you too)..
Appreciate the nature theme, chances are good I'll actually submit something again this week.
: ] -
• #1613
Yes great winner...
...and a personal worst for me ;) -
• #1614
-
• #1615
Unbeatable.
-
• #1616
Indeed! The subtle interplay of light and shade. The symmetry. Magical. :)
-
• #1617
Unbeatable
Hoping for personal best with this 2 votes;)
-
• #1618
Amazing - I was going to go and grab a deer's arse (as it were) on my way home tonight!
-
• #1619
Yeah, the arses theme would be amazing.
-
• #1620
+1 for arses theme.
I had (have?) a good plan for this week but the crystal shop in Waterloo was closed today :(
Might have to resort to one of those psychedelic vector cabbages from the market.
-
• #1621
Romanesco.
-
• #1622
Ninna nanna, nanna ninna,
er pupetto vò la zinna:
dormi, dormi, cocco bello,
sennò chiamo Farfarello...Trilussa
-
• #1623
^ yeah me too
-
• #1624
This thred needs moar pictures :)
-
• #1625
Olympus E-M10, tweaked in RawTherapee
f/5.6, 1/320, ISO 400, 150mm (300mm equivalent)
#neatnessinnature
1 Attachment
thross
HHC
MrDrem
mi7rennie
salad
moocher
f1s
skydancer
marcom
KDense
Well_is_it
mashton
hp93
ah, that's a dead easy one. Just graph the responses on Sheet2 of the google sheet, and push it onto it's own page (I think from the dropdown on the top left of the graph when embedded in the sheet). then hide the other two sheets (Form Responses and Sheet2).
(I'm actually playing with HAM'R spreadsheets, rather than getting extra nap :) )