Limited listings

Is there any way to show only a certain number of items in a list. If you were making a storefront like Amazon but you don’t want to show all the books or all the tech products all at once. So display 6 of the latest books with an optional button to view all books? Then have another display for the latest 6 hard drives. Etc.

Maybe there’s a way to create that in sheets by referencing rows from the “products” tab? Just select the top 6 rows or something?

1 Like

The referencing option in the sheet is all I can think of right now.

You can try this method =QUERY(MASTER!A:G,“order by A desc limit 6”) to query only 6 latest item from ‘MASTER’ sheet


Did you get this to work? Thanks