google sheets automatic update rook

The solution for “google sheets automatic update rook” can be found here. The following code will assist you in solving the problem.

function storeFollowers(){
var sheet = SpreadsheetApp.getActiveSheet();
var datarange = sheet.getDataRange();
var numRows = datarange.getNumRows();
var numColumns = datarange.getNumColumns();
var nextColumn = numColumns + 1;
sheet.getRange(1, nextColumn).setValue(new Date());
for (var i=2; i <= numRows; i++){ var numLikes = sheet.getRange(i, 3).getValue(); sheet.getRange(i, numColumns + 1).setValue(numLikes); } }

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

inline scripts encapsulated in