Results 1 to 2 of 2
  1. #1
    boy's Avatar
    Join Date
    Mar 2014
    Gender
    female
    Location
    MEGAN ft $NOT
    Posts
    3,090
    Reputation
    1097
    Thanks
    761
    My Mood
    Scared

    $1 CASHAPP OR ZELLE TO FIRST PERSON WHO FIXES THIS JAVASCRIPT

    - range notation change for trigger event
    - top row onChange for Net Liquidity

    also, i'll send an ADDITIONAL $3 if you can create a Google Sheet that updates with top row as newest input; example:
    [SPOILER]
    Benchmark uses =GOOGLEFINANCE(benchmark,"price",start_date,today( ))
    Instead of the formula going downwards for each update, I want it going upwards and creating new rows
    And first page 'Net Liquid' sheet doing the same








    [/SPOILER]


    Code:
    function createSpreadsheetOpenTrigger(e) {
        if (!e) {
            throw new Error('Script now running');
        }
        if (e.range.getA1Notation() !== 'A2') {
            return;
        }
        var ss = SpreadsheetApp.getActive();
        ScriptApp.newTrigger('myFunction')
            .forSpreadsheet(ss)
            .onOpen()
            .create();
    }
    sh.insertRowAfter(1);
    sh.setRowHeight(2, 21);
    var freeze = sh.getRange("A2:C2");
    freeze.copyTo(freeze, {
        contentsOnly: false
    });
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var sh = ss.getSheetByName("Examples");
    sh.insertRowAfter(1);
    sh.setRowHeight(2, 21);
    sh.getRange("A2").setFormula('=RAW!A3');

  2. #2
    boy's Avatar
    Join Date
    Mar 2014
    Gender
    female
    Location
    MEGAN ft $NOT
    Posts
    3,090
    Reputation
    1097
    Thanks
    761
    My Mood
    Scared
    nvm i did it already please close this thread // @Azerila

Similar Threads

  1. FREE BRONZE BOOST ON EUW /EUNE RIGHT NOW FOR FIRST PERSON WHO ADDS ME
    By BoostersPro in forum League of Legends Discussions
    Replies: 3
    Last Post: 11-01-2017, 07:35 PM
  2. [Solved] ill paypal a dollar to the first person who can help me.
    By w0lfzy in forum Call of Duty Black Ops 2 Help
    Replies: 3
    Last Post: 01-09-2015, 11:30 AM
  3. [Solved] I AM THE FIRST PERSON WHO CAN TELL YOU HOW TO (RECOVER UR ACC )
    By anamasryaraby in forum CrossFire Help
    Replies: 1
    Last Post: 07-06-2012, 08:19 PM
  4. [Release] Giving DF account with over 1m of items to the person who does this job.
    By dharokpl0x in forum Hack Requests
    Replies: 0
    Last Post: 05-08-2012, 07:34 PM
  5. NEED A FRIEND FOR GLITCH VID- first person who replys gets to be in the vid--
    By XxDrazzoXxZ in forum Combat Arms Hacks & Cheats
    Replies: 20
    Last Post: 10-19-2008, 05:28 PM