Google-sheets – way to write in the data of one cell from another cell via a function

google sheets

For example, say I have some data in A1, and I want to write it in C1, is there a function I could use that does this?

I know you can write in via cell C1 "=A1" which would obtain the result of A1, however, I want cell C1 to maintain the value of A1 even if the cell in C1 is moved, for e.g to D1.

Best Answer

If we drag-and-drop C1 to another position, its formula will remain unchanged: =A1.

If we copy or cut C1 and paste it to D1, then A1 will be automatically adjusted to B1, because it's a relative reference. To avoid this use an absolute reference =$A$1.

If we want to keep C1 in place but copy its formula while keeping the reference unchanged, apply the same, use an absolute reference, in this case =$A$1.

Related Solutions

Google Sheets Formula – Compare Two Cells and Write Answer

I believe this is what you want. If the comments in the code isn't enough, feel free to ask me for assistance.

function compareCells(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();                   //Get active Spreadsheet
  var listSheet = ss.getSheetByName('Sheet15');                     //Get sheet "Sheet15"
  var dataSheet = ss.getSheetByName('Raw Data');                    //Get sheet "Raw Data"
  var listSheetLastRow = listSheet.getLastRow();                    //Get number of last row with data in "Sheet15"

  var currRow = 2;                                                  //Start looping on row to, since row 1 is header

  for (i = 2; i <= listSheetLastRow; i++){                          //For-loop, looping through all rows with data in "Sheet15"
    var ticker = listSheet.getRange(currRow, 1).getValue();         //Getting value in column A in current row from "Sheet 15"
    dataSheet.getRange(1, 2).setValue(ticker);                      //Setting above value in cell A1 in "Raw Data"
    Utilities.sleep(40000);                                         //Pausing for 40 seconds (40 000 milliseconds)

    var value1 = dataSheet.getRange(7, 2).getValue();               //Getting value from B7 in "Raw Data"
    var value2 = dataSheet.getRange(13, 2).getValue();              //Getting value from B13 in "Raw Data"

    if (value1 > 0.1 && value2 > 0.1){                              //If both values gotten above is greater than 0.1 (10%)
      listSheet.getRange(currRow, 8).setValue('True');              //Set the value of the cell in current row, in the H column to "True"
    }else{                                                          //Else
      listSheet.getRange(currRow, 8).setValue('False');             //Set the value of the cell in current row, in the H column to "False"
    }
    currRow++;                                                      //Go to next row
  }
}

Google-sheets – Pull data from one sheet (has a locked cell) to another sheet (has a locked cell) every day automatically

Instead of using an simple on edit trigger use an installable trigger as it runs with the trigger creator credentials.

Best Answer

Related Solutions

Google Sheets Formula – Compare Two Cells and Write Answer

Google-sheets – Pull data from one sheet (has a locked cell) to another sheet (has a locked cell) every day automatically

Related Topic