How to compare value of a cell <-> string

Question

I'm looking to compare the value of a cell to a string. (In google scripts)

function MyMovingTrigger() {
  var ss = SpreadsheetApp.openById("MYIDHERE"); 
  var sheet = ss.getSheetByName("SHEETNAMEHERE");

  if(sheet.getRange('B2').getValue()=="TRUE") { 
    //more code here
  }
}

//The value in B2 is the following:
//this will either display "TRUE" or "FALSE"
=ISREF(INDIRECT("Copy of Empty"&"!C1"))

The error I get back is the following: ReferenceError: Function function getValue() {/* */} can not be used as the left-hand side of assignment or as an operand of ++ or -- operator. at MyMovingTrigger(Code:8)

This seems to have been asked before and answered. Please check here: https://stackoverflow.com/questions/14109538/trying-to-read-cell-1-1-in-spreadsheet-using-google-script-api — Jitendra Singh, May 06 '19 at 13:38

score 0 · Answer 1 · answered May 06 '19 at 15:26

0

You can try this:

if(sheet.getRange('B2').getValue() == true) {

i.e get rid of the quotes around TRUE and put in lowercase.

answered May 06 '19 at 15:26

utphx

1,287
1
8
19

How to compare value of a cell <-> string

1 Answers1