Make Google Sheets Wait using a Function

Cell calculation order

You can’t deliberately delay the execution of an entire Google Sheet using a cell function. Most of the in-built formula functions on you can use in a cell execute very quickly. Some of them, such as IMPORT functions, can take a little time to return data. But these, like any Apps Script function you can … Read more

Do, For and While Loops in Google Sheets

An example sheet showing a do, for and while loop used to update cells

There are 3 types of loops you can use when writing JavaScript inside the Apps Script editor in Google Sheets. Those are do,for and while loops. They each work slightly differently. For loops are our favorite construct when updating all the cells in a range. They offer outstanding performance and make for easily readable code. … Read more