Posts by Yan • 1 point
4 posts
-
0
votes1
answer936
viewsA: How to run multiple onEdit functions in the same script (google Sheets)?
I solved with the following code: function onEdit(e){ var ss = e.source; var sheet = ss.getSheetByName('Sheet1'); var value = e.value; var range = e.range; value = value.replace(new…
-
0
votes1
answer936
viewsQ: How to run multiple onEdit functions in the same script (google Sheets)?
I tried several ways and none worked. I want a function that when someone types something, the cell content automatically becomes all uppercase and no accents. E.g.: if I type "aaaauu", it…
-
0
votes2
answers167
viewsA: How to filter so that accents are not differentiated in Google Sheets?
The way I got it was this: function tiraacento(){ var app= SpreadsheetApp; var targetSheet= app.getActiveSpreadsheet().getSheetByName("Sheet1"); var cidades= targetSheet.getRange("I:I").getValues();…
-
0
votes2
answers167
viewsQ: How to filter so that accents are not differentiated in Google Sheets?
Hello, I have a column with names of cities, that the names are placed in different ways: "São Paulo", "SAO PAULO", "Sao Paulo", "São Paulo", etc. I need to filter this column, even with a script,…