iGoogleDrive

Question: ( by Violet ) I'm new to Google Docs and have recently created a Google Form with responses contained in a Google Sheet.  ...

Question: ( by tomtom328 ) Dear all,  I like to create a formula for inventory count: Column O (of many sheets) outlines the di...

Question: I'm using the =ImportHtml function to get some data from an HTML table. It works okay, but I need it to refresh. The HTML...

If you are new to Google Spreadsheets and you have never written a script before or if you don't know anything about it, then this tuto...

Send a Google Spreadsheet sheet to an email address weekly or daily or hourly or minutely by setting a timer trigger. You must have bee...

Let's see a example of it: I'm trying to have my spreadsheet that calculates SUM values according to the person's name sele...

I tested this issue repeatedly by deleting and adding rows and then selecting whole data by pressing "ctrl + A", and what I found...

If you are wondering how to count a specific value (may be a number or a name or a date or any content of a cell) from a specific range of ...

If you are having a huge amount of rows in your spreadsheet, then you must be wondering how to navigate to your desired row immediately, ...

Suppose you want to get "FAIL" in a cell if a certain criteria is met in another range of cells. So in the table below, J4 would ...

If you want to refer a cell to a Spreadsheet from different Spreadsheet, then here is the formula which will do your job: =ImportRange(...

While opening a spreadsheet, you may notice that, it opens normally but only for a second, then the page goes blank, "grey screen appe...