Tag Info

Hot answers tagged


With the new Google Cloud Console the procedure to obtain the P12 key has changed: Open the project, go to APIs & auth > Credentials Click on Create new Client ID, and select Service account and P12 key. Then click on Create Client ID to download it.


You can add the alias in the advancedArgs as shown here: var alias = "email@example.com"; GmailApp.sendEmail(person[1], emailSubject, emailMsg, {from: alias});


I always use the ISNA() function. As a first step, I create the range with filter(): =FILTER( TRANSACTIONS! C4:C51; TRANSACTIONS! D4:D51="Other"); As a second step, I always use the: =IF(ISNA(range);0;thingsToDoWith(range)); So, in your case it will become: =IF(ISNA(FILTER( TRANSACTIONS! C4:C51; TRANSACTIONS! D4:D51="Other"));0;SUM(FILTER( ...

Only top voted, non community-wiki answers of a minimum length are eligible