I need a script that increments the value of a cell by 1.

[Michael]

I'm making a macro that does several things, but one thing I want it to do is to increment the value in a specific cell by 1.  For the life of me, I can get it to do everything else I want (including selecting the cell in question), but I can't figure out how to get it to add +1 to that cell.

[Brett Grear]

Can you share the current script you have?

[Martin Molloy]

try this

function incrementCellValue(){

let spreadsheet = SpreadsheetApp.getActiveSpreadsheet()

let targetSheet = spreadsheet.getSheetByName('Sheet1')

let targetCell = targetSheet.getRange('A1')

let currValue = targetCell.getValue()

if(isNaN(currValue)){

  console.log('Cell does not contain a number')

  return

}

let newValue = currValue+1

targetCell.setValue(newValue)

}

Martin 

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/570a7d86-359a-4290-bc1c-330ae28509b9n%40googlegroups.com.

[Michael]

Thanks, that works!