I have a Google Sheet with about 300 rows in it. A couple of the columns have formulas like this:
=IF(ISBLANK(E210),C10, QUERY(importrange(SheetKey,"SheetName!A:B"),"select Col2 where Col1="&E10,0))
What the formulas do: When an ID number is entered in one cell, the other cell retrieves information from another cell of the row where the ID number is found. You may preview a copy at https://drive.google.com/previewtemplate?id=14yB8lqTdFvszLs7eaJcWQXVPtQcqBUjp4dJqIY_Yfx4&mode=public -- see the "Rabbits_List" tab.
While entering new rows, there seems to be quite a bit of lag, I am guessing because of those formulas.
Is there a way to tie those cells updates to a script, so it can be linked to a button and run on demand?
I am using Google Sheets with the Chrome browser.