Writing a script for Google Sheet
11 USD If the value changes in the cell G4 (this changes as a result of selecting the value from the cell F4), the
perform the purification of the values in the F16:F33 range and enter the formula =IF($G$4>=2,C16,$J$17)
Copy the values that are obtained by the calculation of the formula.
That is
If G4 = 1, then the brick in F16:F33 (one cleaning, then you can enter the data manually and the data remains)
If the G4 >= 2, then make a glimpse in F16:F33 and insert the formula =IF($G$4>=2,C16,$J$17) in the same range.The function must work when the value is only changed in G4 (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){
by Num();
Link to the table
https://docs.google.com/spreadsheets/d/1vQnDaF2ekm7edicGYU0e3pZHonfrHUArVgpruHf-mAU/edit#gid=359307665
The code can be entered into the app scripts on your own and check if everything works properly.Access to the editing table provided
Current freelance projects in the category Javascript and Typescript
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 hours 35 minutes back ∙ 10 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 ∙ 22 hours 52 minutes back ∙ 24 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 ∙ 2 days 2 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 ∙ 2 days 20 hours back ∙ 89 proposals |
Consultation and audit of the current project on Odoo 19 Community Edition
We are looking for an Odoo Developer — a solo developer with experience in Odoo 19 Community Edition, including using Claude Code. We need a specialist who has successfully implemented projects in Odoo and practical experience in development using Claude Code. Important: we only… C & C++, Javascript and Typescript ∙ 3 days 1 hour back ∙ 7 proposals |
Kyiv