# Random numbers change in googlesheet but not in Glide Data **URL:** \ **Category:** Report a Bug\ **Created:** [January 30, 2020, 5:03pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117 "2020-01-30T17:03:35Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Anna\_Riabzev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anna_riabzev/32/3087_2.png) [@Anna\_Riabzev](https://community.glideapps.com/u/Anna_Riabzev)\ **Post date:** [January 30, 2020, 5:03pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/1 "2020-01-30T17:03:35Z")
My app’s URL: [https://r4ale.glideapp.io](https://r4ale.glideapp.io) I want my app to show random messages, so I’ve created in my GoogleSheets table a column with a formula that generates random numbers, and I set up the visibility according to the numbers in this column. The thing is that although the numbers do change in the google sheet, they remain the same in the Glide app data. Even if I press “Reload Sheet”. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 30, 2020, 6:32pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/2 "2020-01-30T18:32:42Z")
I’ve tried this too…it’s a pro app feature to retrieve data in intervals. Rand(), Today() and Now() aren’t considered “edits to sheets” to refresh the app. ---
**Author:** ![Anna\_Riabzev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anna_riabzev/32/3087_2.png) [@Anna\_Riabzev](https://community.glideapps.com/u/Anna_Riabzev)\ **Post date:** [January 30, 2020, 7:00pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/3 "2020-01-30T19:00:51Z")
Thank you Robert! Well, that’s a bummer ☹ Do you know maybe some other workaround to choose randomly from a list? ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [January 30, 2020, 7:20pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/4 "2020-01-30T19:20:25Z")
We have a ‘Shuffle’ sort option for lists that can sort of do this. ---
**Author:** ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)\ **Post date:** [January 30, 2020, 7:49pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/5 "2020-01-30T19:49:23Z")
If you can get the user to submit a form. It does not have to have any input. I just make a form where the current timestamp goes to a sheet. This changes the sheet and then sends a new random number. Here is a fun app that picks a different phrase after each form submit. [https://magic8.glideapp.io](https://magic8.glideapp.io) ---
**Author:** ![Anna\_Riabzev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anna_riabzev/32/3087_2.png) [@Anna\_Riabzev](https://community.glideapps.com/u/Anna_Riabzev)\ **Post date:** [January 30, 2020, 10:33pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/6 "2020-01-30T22:33:07Z")
Thank you, spencersRus! ---
**Author:** ![Anna\_Riabzev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anna_riabzev/32/3087_2.png) [@Anna\_Riabzev](https://community.glideapps.com/u/Anna_Riabzev)\ **Post date:** [January 30, 2020, 10:34pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/7 "2020-01-30T22:34:20Z")
Thank you, David! I’ll check out this option. ---
**Author:** ![Anna\_Riabzev](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/anna_riabzev/32/3087_2.png) [@Anna\_Riabzev](https://community.glideapps.com/u/Anna_Riabzev)\ **Post date:** [January 30, 2020, 11:01pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/8 "2020-01-30T23:01:37Z")
Hi David, I saw the shuffle option, It’s a nice workaround. Thanks! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [January 31, 2020, 3:26pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/9 "2020-01-31T15:26:14Z")
That’s what I was going to suggest. There needs to be an edit to the sheet that Glide recognizes…only way I know how to do that is a toggle (marks true/false) or form submit. ---
**Author:** ![Tyler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tyler/32/5637_2.png) [@Tyler](https://community.glideapps.com/u/Tyler)\ **Post date:** [April 15, 2020, 5:39pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/10 "2020-04-15T17:39:39Z")
@Anna_Riabzev @spencersRus Trying to build something fun, like a game where you collect pieces and prizes by rolling a dice. Just can’t seem to figure out how to return a random cell from a column. I tried the Form Submit to send a timestamp - but the issue is that after a user has pressed the Submit button in the top right, it just goes right back to the screen that took us to the form submit. Is there a way to have a new screen appear after a user submits the form? Thanks! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 15, 2020, 5:47pm UTC](https://community.glideapps.com/t/random-numbers-change-in-googlesheet-but-not-in-glide-data/4117/11 "2020-04-15T17:47:31Z")
Hi @Tyler, I explain it here: > [@Fun and Games App: Added Slots!](https://community.glideapps.com/t/fun-and-games-app-added-slots/5703): > > wave Hi all! After playing around with some ideas for randomizers, I came up with this little gem. [https://funandgames.glideapp.io](https://funandgames.glideapp.io) Inspiration: stuck inside playing board games with the kids and we couldn’t for the life of us find dice for our game. Added a random name selector because my girls couldn’t decide who would pick the next game. I’m taking requests to include other randomizers/ mini-games/ selectors…just reply to this post below! Here’s a preview: