Question

98

Increment cell value in spreadsheet Google Appscript

rated 0 times [ 100] [ 2] / answers: 1 / hits: 7708 / 10 Years ago, mon, december 8, 2014, 12:00:00

I want to increment the value in the A1 cell.

function increment(){

   var ss = SpreadsheetApp.getActiveSpreadsheet();

   var sheet = ss.getSheets()[0];



   var cell = sheet.getRange(A1);

   cellValue = cell.getValue(A1);

   cell.SetValue(cellValue + 1);

}

How can I do that?

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

rociom

Add To Favorites

Follow

Total Points: 287

Total Questions: 88

Total Answers: 101

Location: Oman

Member since Wed, Nov 17, 2021

3 Years ago

rociom questions

1 Custom URL in Vite dev server (multi page app)

Mon, Sep 6, 21, 00:00, 3 Years ago

1 JavaScript dialogs alert(), confirm() and prompt() in cross origin iframe does not work any longer

Thu, Jul 22, 21, 00:00, 3 Years ago

1 How do I upload a custom emoji to my discord bot

Tue, Feb 2, 21, 00:00, 3 Years ago

1 Send multiple axios requests in a for loop in series (One after the other)

Mon, Nov 16, 20, 00:00, 4 Years ago

1 How to get require.context to work with Create React App with/withou Craco?

Sun, Jan 19, 20, 00:00, 4 Years ago

View All

answered 10 Years ago ellisw · Accepted Answer

You are calling getValue() with an argument. This function does not take any arguments, as can be seen in the documentation:

https://developers.google.com/apps-script/reference/spreadsheet/range#getValue()

  function increment(){

   var ss = SpreadsheetApp.getActiveSpreadsheet();

   var sheet = ss.getSheets()[0];



   var range = sheet.getRange(A1);

   //Returns the value of the top-left cell in the sheet

   var value = range.getValue();

   range.setValue(value + 1);

}