Writing a script for Google Sheet $400.
11 USD 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
Client's review of cooperation with Mykhailo Shcherbachuk
Writing a script for Google Sheet $400.Qualitative and careful work! The work was brought to the end and even overworked. I highly recommend Michael!
Freelancer's review of cooperation with Andrey Akopov
Writing a script for Google Sheet $400.I strongly recommend Andrea for cooperation. It is a clear task, a timely payment.
Current freelance projects in the category Javascript and Typescript
Development of the AM Mobility platform (car service, parking, insurance, car rental)
5770 USD
We are looking for a team or an experienced Full Stack developer to create the MVP of the AM Mobility platform. AM Mobility is a unified digital ecosystem for motorists, combining in one application and web platform: parking; car service; tire fitting; car wash; car rental;… Javascript and Typescript, Web Programming ∙ 3 days 1 hour back ∙ 102 proposals |
Gsap animations
22 USD
Good day. Corrections need to be made in the current project. A specialist is needed who works well with gsap/lenis. Animation of cards needs to be done. Detailed specifications here:… Javascript and Typescript, Web Programming ∙ 3 days 7 hours back ∙ 21 proposals |
Commercial on-premise video communication platform "ViM"It is required to develop an on-premise video conferencing system with a basic calculation for 100 simultaneous connections (10 isolated rooms of 10 people each). The platform should have a built-in architecture for future horizontal scaling up to 1000 users by adding new media… Javascript and Typescript, Web Programming ∙ 4 days 3 hours back ∙ 32 proposals |
I am looking for a mentor with Claude Code to launch a web project from scratch.Brief about the task: I am a beginner with no programming experience. I have a ready specification for website development (42 pages, Next.js, PostgreSQL). I want to implement it myself using Claude Code - I need a specialist who will set up the environment and teach me how to… Javascript and Typescript, Tuition ∙ 5 days 6 hours back ∙ 18 proposals |
Website design updateIt is necessary to update the design of the existing website using HTML, CSS, JS: refresh the appearance, make it modern and responsive for mobile devices. Smooth animations and interactive elements need to be added. HTML & CSS, Javascript and Typescript ∙ 6 days back ∙ 90 proposals |
Kyiv