Project translated automatically. Log in or register, to view the original The Task: If the value changes in the cell G5 (this changes as a result of selecting the value from the cell F5), the Execution of the F15:F34 range enter this range of formula =IF($G$5>=2,C15,$J$17) Copy the values that are obtained by the calculation of the formula. The function must work when the value is only changed in G5 (i.e. it must be the onEdit(e)) instead of being continuously performed.Writing the code: Function Num() { is spreadsheet = SpreadsheetApp.getActive(); var sheet = spreadsheet.getSheetByName('Man'); var range = sheet.getRange ('F15:F34'); range.clear({contentsOnly: true, skipFilteredRows: true}); var formula = '=ArrayFormula(IF($G$5>=2,C15,$J$17))'; the range.setFormula (formula) by Range.activate() Range.getValues() range.copyTo(sheet.getRange("F15:F34"), SpreadsheetApp.CopyPasteType.PASTE_VALUES,false); The function onEdit(e) { var range = SpreadsheetApp.getActive().getSheetByName('Man').getRange('G5');getValue() and range = e.range if(range.getValue() = 2 = 2 by Num(); Link to the table https://docs.google.com/spreadsheets/d/18L_GzUj5FcoP89HPrHWIm0VJPdYk-bcPGIpgYQDLJ8c/edit#gid=359307665

Proposals 3

Mykhailo Shcherbachuk

Winning proposal

1 0

Projects -
Rating -
Rating 336

Budget: 500 UAH Deadline: 1 day

Good day . I have an option to solve this task. I want to help you with this.

Vitalii P.

11 0

Projects 11
Rating -
Rating 489

Budget: 600 UAH Deadline: 1 day

I can do the function quite quickly, I have experience working with AppScript.

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Andrey Akopov
Kyiv, Ukraine
Швейний цех Велма

Projects 3
Rating -
Rating 89

Writing a script for Google Sheet $400.

Client's review of cooperation with Mykhailo Shcherbachuk

Writing a script for Google Sheet $400.

5.0

Andrey Akopov

Freelancer's review of cooperation with Andrey Akopov

Writing a script for Google Sheet $400.

5.0

Mykhailo Shcherbachuk

Mykhailo Shcherbachuk

Vitalii P.

Proposals are currently absent

Current freelance projects in the category Javascript and Typescript

Development of Telegram Mini App (RPG Game)

Automation of creating vertical videos of one type using a plugin in After Effects.

Development of a Tampermonkey script for automating responses in the internal CRM via the OpenAI API.