As per the title, I want to "move" the contents of a cell one column to the right once a week, specifically Sunday at 11pm
Must I use a script for that?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityAs per the title, I want to "move" the contents of a cell one column to the right once a week, specifically Sunday at 11pm
Must I use a script for that?
This piece of script will move the first entry of a row range to the next column:
function myShift() {
var sh = SpreadsheetApp.getActiveSheet();
var data = sh.getRange("1:1").getValues();
var counter=0;
for(var i=0, iLen=data[0].length; i<iLen; i++) {
if(data[0][i] == "") {
counter++;
} else {
data[0][counter+1] = data[0][i];
data[0][counter] = "";
break;
}
}
sh.getRange("1:1").setValues(data);
}
I've created an example file for you: Copy and Paste Cell Contents Once a Week
Add the script under Script Editor from the Tools menu. Press the "bug" button to debug the code and to authenticate the script. Goto Resources (in the script editor) and set the trigger as shown.