New answers tagged

-4

i changed the code as suggested but it doesnt compare function sendEmails() { var spreadsheet = SpreadsheetApp.openById('1AVv6X-y-5g9L2qnx-TszWuhypjSQgStvmlRnEfIzbSo'); // 0AkGlO9jJLGO8dDJad3VNTkhJcHR3UXlJSVRNTFJreWc var sheet = spreadsheet.getSheets()[0]; // gets the first sheet, i.e. sheet 0 var range = sheet.getRange("B1"); var dateString = ...


0

To keep track of running maximum of the content of some cell, one needs a script that runs every time the cell changes value. Such a script could be triggered by the same button you are using to force recalculation, although a delay (Utilities.sleep(1000), time in milliseconds) may be necessary to make sure the recalculation runs before this script. Or, if ...


0

In a cell of your choosing enter the formula: =max(A1:A7) Where A1:A7 are the cells of interest. A1:A7 interprets as cells A1 through A7, in a column. A1, A2, C1, C2 interprets each cell is looked at indiviually. A1:A7, B1, C1:C3 or any combination. =max(A1:A7, B1, C2, D1:D20)


0

The main problem with your current function lies in the extra = and the unnecessary use of concat. If you're interested in a simplified method you can try this: You can parse it by just extracting the digits using regexextract: =IFERROR(REGEXEXTRACT(A1,"\d+"),0) to explain - the inner function regexextract is basically specifying to only extract the ...


2

The = before the IF() is the first problem. The = is only needed at the beginning of the formula, not when nesting functions. Remove the Concat() from the formula. It does not look like you want to concatenate anything, since the IF() is the only argument and your desired outcome is just a number. The last nested IF does not have a "false" parameter. If ...



Top 50 recent answers are included