# \[Video Tutorial\] Always show the last 4 items in your home screen

**URL:** <https://community.glideapps.com/t/video-tutorial-always-show-the-last-4-items-in-your-home-screen/1270>\
**Category:** Ask for Help\
**Created:** [October 19, 2019, 2:28pm UTC](https://community.glideapps.com/t/video-tutorial-always-show-the-last-4-items-in-your-home-screen/1270 "2019-10-19T14:28:54Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paolo\_Falconi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paolo_falconi/32/1019_2.png) [@Paolo\_Falconi](https://community.glideapps.com/u/Paolo_Falconi)\
**Post date:** [October 19, 2019, 2:28pm UTC](https://community.glideapps.com/t/video-tutorial-always-show-the-last-4-items-in-your-home-screen/1270/1 "2019-10-19T14:28:54Z")

</div>

Hello Glide comunity,

Today I’ll teach you how to always show the latest 4 items in your homescreen of your Glide app using a few formulas on your spreadsheets

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/8/38b4a01f1292064f02b820121526e266093f62e0.jpeg "[GLIDE APPS TUTORIAL] Showing the latest items on your home screen") ](https://www.youtube.com/watch?v=srpO4IfO9Og)

The formulas i use in the video are:

=ARRAYFORMULA(if($E2:$E = index($E$2:$E, COUNTA($E$2:$E)),“TRUE”, ) & ARRAYFORMULA(if($E2:$E = index($E$2:$E, COUNTA($E$2:$E)-1),“TRUE”, )) & ARRAYFORMULA(if($E2:$E = index($E$2:$E, COUNTA($E$2:$E)-2),“TRUE”, )) & ARRAYFORMULA(if($E2:$E = index($E$2:$E, COUNTA($E$2:$E)-3),“TRUE”, )))

The explanation is:

**if($E2:$E = index($E$2:$E, COUNTA($E$2:$E)),“TRUE”, )**  
If any item of the “E” column is equal to the last item of the same “E” column then return TRUE, and if not, just leave it empty.

**COUNTA($E$2:$E))**  
This will count all the populated cells in the “E” column starting from “E2”

**index($E$2:$E, COUNTA($E$2:$E)-1)**  
Here we are getting the last value -1 of the “E” column. Index shows the value of a cell in a range, in this case column “E”, and the row is calculated by COUNTA but -1.

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [November 2, 2019, 11:04am UTC](https://community.glideapps.com/t/video-tutorial-always-show-the-last-4-items-in-your-home-screen/1270/2 "2019-11-02T11:04:51Z")

</div>

Great work, thanks for sharing 😃

---

<div class="post-metadata">

**Author:** ![Muhammad\_iqbal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muhammad_iqbal/32/246_2.png) [@Muhammad\_iqbal](https://community.glideapps.com/u/Muhammad_iqbal)\
**Post date:** [November 2, 2019, 12:35pm UTC](https://community.glideapps.com/t/video-tutorial-always-show-the-last-4-items-in-your-home-screen/1270/3 "2019-11-02T12:35:41Z")

</div>

Why you not make new sheet tab, then just use query, order by timestamp and limit 4

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [November 2, 2019, 1:23pm UTC](https://community.glideapps.com/t/video-tutorial-always-show-the-last-4-items-in-your-home-screen/1270/4 "2019-11-02T13:23:44Z")

</div>

Agreed that is what I have used.

---

<div class="post-metadata">

**Author:** ![Paolo\_Falconi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paolo_falconi/32/1019_2.png) [@Paolo\_Falconi](https://community.glideapps.com/u/Paolo_Falconi)\
**Post date:** [November 4, 2019, 6:21am UTC](https://community.glideapps.com/t/video-tutorial-always-show-the-last-4-items-in-your-home-screen/1270/5 "2019-11-04T06:21:17Z")

</div>

because then i would have to create another sheet tab for every category i have and it’s just annoying to have too much sheet tabs haha

---

<div class="post-metadata">

**Author:** ![Aristide\_Salvatore](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/aristide_salvatore/32/5099_2.png) [@Aristide\_Salvatore](https://community.glideapps.com/u/Aristide_Salvatore)\
**Post date:** [March 24, 2020, 9:41pm UTC](https://community.glideapps.com/t/video-tutorial-always-show-the-last-4-items-in-your-home-screen/1270/6 "2020-03-24T21:41:39Z")

</div>

Thanks