3

Part of your problem is that SPLIT, when used as an argument to a function, returns a string. Say your C1 cell contains the text 1,C. Your formula =GetNumber(SPLIT(C1, ",")) is actually equivalent to =GetNumber('1C'); If you are somewhat familiar with JavaScript, you could instead to the split operation within your function code: function ...


1

The regex /$[0-9\s]+/ attempts to match numbers and whitespace immediately after the end of line. That will never match anything. Use /[\s\d]+$/ to match numbers and whitespace immediately before the end of line. You apparently to want to add numbering to the end of headings. The split() and if seem unnecessary and can probably be removed. Simply use this: ...


1

A workaround is pressing Esc right after the mouse click on the button. It's slightly more comfortable than using mouse, but it's still an intermediate step.


1

It is unclear why you would need to use a script, because this can be done with a plain vanilla hlookup() formula, like this: =arrayformula( iferror( hlookup(A6:A15, D6:F7, rows(D6:F7), false) ) ) See the new Solution sheet in your sample spreadsheet. To read the data from another spreadsheet file, use an importrange() in place of D6:F7 and 2 in place of ...


1

Use getNextDataCell(), like this: const spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getCurrentCell() .getNextDataCell(SpreadsheetApp.Direction.DOWN) .offset(1, 0) .activate();


1

You are on the right track as the code is using batchUpdate. I suggest you to spend some time learning about how to handle Arrays in JavaScript. I.E. There is no need to include two batchUpdate as it's possible to put the request object of both in a single one, actually in a single batchUpdate it's possible to include 50 pasteData. Your guess about that both ...


1

You do need to learn how to write scripts OR, at the very least, how to adapt an existing script to your own circumstances. This answer is designed to provide a solution by referencing some existing scripts and also helping with referencing more information. You want a button that will allow me to clear all the cells on all sheets with one click The ...


1

Sumif =INDEX( IF( A3:A = "", "" ,SUMIF( ROW( A3:A ), "<=" & ROW( A3:A ) ,A3:A ) ) ) Option suggested by Adam. Drawbacks: the last parameter of SUMIF needs to be always a "valid range" not easy to add ...


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