Apps Script in Google Sheets for inserting values into empty cells
Please help me create a script for Apps Script in Google Sheets, which inserts a certain value (for example a dot) into empty cells in a certain column (for example A1:A100)
Original question is available on version: ru
Answers:
function fillEmptyCells() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var range = sheet.getRange("A1:A100");
var values = range.getValues();
for (var i = 0; i < values.length; i++) {
if (values[i][0] == "") {
values[i][0] = ".";
}
}
range.setValues(values);
}
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var range = sheet.getRange("A1:A100");
var values = range.getValues();
for (var i = 0; i < values.length; i++) {
if (values[i][0] == "") {
values[i][0] = ".";
}
}
range.setValues(values);
}
11.02.2024, 16:41
I'm glad that you were able to find the answer to your question on a third-party resource.
12.02.2024, 11:04
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
