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
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.
