# Random sort

**URL:** <https://community.glideapps.com/t/random-sort/8447>\
**Category:** Ask for Help\
**Created:** [May 4, 2020, 1:16pm UTC](https://community.glideapps.com/t/random-sort/8447 "2020-05-04T13:16:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ksuttell](https://avatars.discourse-cdn.com/v4/letter/k/7feea3/32.png) [@ksuttell](https://community.glideapps.com/u/ksuttell)\
**Post date:** [May 4, 2020, 1:16pm UTC](https://community.glideapps.com/t/random-sort/8447/1 "2020-05-04T13:16:13Z")

</div>

I want to generate a random tip. But every time I go to the tab it is the same row. What triggers the shuffle? thank you

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 5, 2020, 1:53am UTC](https://community.glideapps.com/t/random-sort/8447/2 "2020-05-05T01:53:10Z")

</div>

Hi Kim,

How are you currenly setting the formula for the “random tip” in your data? Can you give us some screenshots?

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [May 5, 2020, 2:20am UTC](https://community.glideapps.com/t/random-sort/8447/3 "2020-05-05T02:20:23Z")

</div>

Make a list on a different tab. That list should be your tips. The cell that displays the tip just needs to randomize those for you. Lets say cell A2 on sheet1 is the cell displayed in the app. Page 2 could have a list of tips. Lets say that list is cells A2 through A15. The cell A2 on sheet 1 would read:

=RAND(Sheet2!A2:A15).

Everytime the sheet is edited the tip will change.

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [May 5, 2020, 2:21am UTC](https://community.glideapps.com/t/random-sort/8447/4 "2020-05-05T02:21:45Z")

</div>

You could also use the date and time to randomize throughout the day. Here is a link to a similar issue I resolved.

> [@Rollups for count](https://community.glideapps.com/t/rollups-for-count/8146/9):
>
> Thank you. Much appreciated.

---

<div class="post-metadata">

**Author:** ![ksuttell](https://avatars.discourse-cdn.com/v4/letter/k/7feea3/32.png) [@ksuttell](https://community.glideapps.com/u/ksuttell)\
**Post date:** [May 5, 2020, 11:15am UTC](https://community.glideapps.com/t/random-sort/8447/5 "2020-05-05T11:15:26Z")

</div>

That is the question…how does the sheet get edited. If the Detail layout is sheet2, how do you make a change to sheet1. Can you make a button to do that? Thank you

---

<div class="post-metadata">

**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\
**Post date:** [May 5, 2020, 2:35pm UTC](https://community.glideapps.com/t/random-sort/8447/6 "2020-05-05T14:35:03Z")

</div>

Whenever anyone submits data to the sheet. you can do this by making areas editable to your users, a form they fill out, etc.