# Live Audience Poll
**URL:** https://community.glideapps.com/t/live-audience-poll/1202
**Category:** Feature Requests
**Created:** [October 15, 2019, 8:35pm UTC](https://community.glideapps.com/t/live-audience-poll/1202 "2019-10-15T20:35:19Z")
**Posts on this page:** 4
**Page:** 2
### Author:  [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)
#### Post date: [November 10, 2019, 11:13pm UTC](https://community.glideapps.com/t/live-audience-poll/1202/21 "2019-11-10T23:13:29Z")
Thanks for taking the time to do the video of your poll app. Since I have to confess that I’m not the least bit familiar with using formulas in sheets, it’s great to see you explain the basics such as sort and concatenate. Even seeing that I can present the same data in three ways on the same sheet was a big help.
I have to say though that your Google icon is far too scary for a Sunday school teacher. But maybe you have it customised to only appear when viewers require some moral scrutiny? I promise I’ll repent if you stop giving me the evil eye. Ha.
---
### Author:  [@spencersRus](https://community.glideapps.com/u/spencersRus)
#### Post date: [November 10, 2019, 11:15pm UTC](https://community.glideapps.com/t/live-audience-poll/1202/22 "2019-11-10T23:15:45Z")
funny @Les_Henderson I am also an elementary school teacher. That google icon was taken one day at my desk as I was playing around with a new laptop/webcam. It was meant to be more bored than scary. But with 5th graders, I will take the scary look! HAHA
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [November 11, 2019, 11:56pm UTC](https://community.glideapps.com/t/live-audience-poll/1202/23 "2019-11-11T23:56:33Z")
Not even going to attempt to wrap my head around that formula. It’s easier for me to understand something when I can apply it to my own situation. I just wanted to offer some additional information. Doesn’t quite apply to your situation, but it’s a good formula to keep in the back of your mind. The attached thread shows how to find the last record that matches a search term. It’s good if you just need to find that last submission for a particular user, but not as useful for a poll.
> [@Display the latest item from my sheet](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/2):
>
> Yes, this formula returns the last item that matches a search value: =IF(ISERROR(ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B))), "", ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B))) This is what I use in the Photo Choice example in [https://concepts.glideapp.io/](https://concepts.glideapp.io/) Here is a simplified version with the conversion from ( , ) to ( ; ) for you: =ARRAYFORMULA(LOOKUP(2; 1/(FormResponseSheet!A$2:A=A3); FormResponseSheet!B…
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [November 12, 2019, 12:09am UTC](https://community.glideapps.com/t/live-audience-poll/1202/24 "2019-11-12T00:09:16Z")
I tried and failed to understand that sheet formula as well. I figured out pieces of it but I have no idea how it works, and that would scare me a little if I was using it.
[Previous page](https://community.glideapps.com/t/live-audience-poll/1202.md?page=1)