Posts by Alisson Miranda • 16 points
3 posts
-
0
votes1
answer261
viewsA: I’m getting this error message >>> Typeerror: Cannot read Property 'pop' of null (line 5, "Code" file)
On lines 5 and 8 change ; for ,. In Brazil this is the standard tab. function sumByColor(sumRange,colorRef) { var activeRg = SpreadsheetApp.getActiveRange(); var activeSht =…
-
0
votes1
answer247
viewsA: Convert Macro excel to Google Sheets script
This script will do this on all worksheets, if you want to do it only on a specific worksheet you will need to make some changes. function onEdit(e){ const ss = e.source; let value = e.value; let…
google-sheetsanswered Alisson Miranda 16 -
0
votes1
answer66
viewsA: How to create a function that creates a new page in google Sheets
Try this: function onOpen() { SpreadsheetApp.getUi() .createMenu('Extras') .addItem('Criar planilha', 'showPrompt') .addToUi(); } function showPrompt() { const ui = SpreadsheetApp.getUi(); const…