Strategy For Large Datasets - Input Appreciated!

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

1 Like