Tag Info

New answers tagged

1

Short answer Replace Renewals!B:C by Renewals!A:J Explanation The problem is that the second parameter of the QUERY() function is doing references to column 10 while the columns specified by the range in the IMPORTRANGE() function only include two. The solution could be 1. To change the range parameter of the IMPORTRANGE() to include enough columns. 2. ...


1

This is a good use case for the SUMIF function. An example is illustrated below:


1

You can use a pivot table to do that. Choose Data > Pivot from the menus, and follow the prompts to set it up. There's an example of something similar here: https://docs.google.com/spreadsheets/d/1VIeA4zAjID0y1jo1FnsbfGA4qmpRgAxMykLXi1pOfhc/edit?usp=sharing


2

Once you are running code in the Sheet, you can loop through the column to see if the values you care about are set or not. You can then only send the email if your criteria are met. Keep in mind that if your logic is if (empty > 20) you will get an email on entry 20, 21, 22, etc. You may want to send one every 5 entries over 20 or something like that.


0

While the formula added by Brian Bennet works, it takes a significant amount of time to update and feels somewhat clunky in an arrayformula. Instead, I used INDIRECT to solve my problem : A | B | C ------------------------------------------------------------ 1| =SUM(INDIRECT("'Raw Data'!A:A")) | ...


0

I would use something like the =importrange() function in Google Sheets because the referenced sheet in that formula doesn't change. The formula needs two things - a Spreadsheet Key, which is specific to the entire workbook, and a range to import. The Spreadsheet Key is in the URL: https://docs.google.com/spreadsheets/d/SPREADSHEET KEY ...



Top 50 recent answers are included