Strategy For Large Datasets - Input Appreciated!

[ThinhDinh]

@V88

Presumably the “admin” email column needs to be populated with an ARRAYFORMULA in the sheet in order to have it “ripple” down through?

Yes that’s what I mean. Have an arrayformula to autopopulate the admin email in the “Email 2” column.

Regarding the sheet row count, Manan have explained it to you, the duplicated sheet in my idea will be used to display in the app, the original one, which you use the form to write to, will stay in the Sheet and not counted towards your row count or affect your app performance.

Here’s the method

How would I duplicate a sheet to only show an updated list of the 'last 10 items logged by each user'

Hi Jaime, this was a bit of a tricky one. I’m used to group-wise ranking in SQL but have never tried this in Google Sheets, interesting use case. For this one I have 2 steps: Ranking group-wise by a script (as Arrayformula, Rank and If can’t work together in my experience). Query to return only rankings less than or equal a pre-defined number. [image] In this example I tried to return 3 latest entries for each type of user (A & B). The script I used for the custom function: funct…