New answers tagged

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 ...


0

Here is an updated version that does not use regex. The regex started breaking for no good reason. function has_strikethrough(reference) { var sheet = SpreadsheetApp.getActiveSheet(); var formula = SpreadsheetApp.getActiveRange().getFormula(); var fParts=formula.split(')').shift() var rang=fParts.split('(').pop() try { var range = sheet....


Top 50 recent answers are included