FANDOM


This talk page is for discussing the Demon boss/Strategies page.

199.58.182.107 03:59, November 25, 2017 (UTC)I made this spreadsheet to help hunt them down. it should insert the timestamps automatically and be very easy to use. multiple people can use it at the same time. I has spript to insert the current date and time. the script it uses is below and the link is https://docs.google.com/spreadsheets/d/1SrUskS_2RYQ75ZKisQsbAC9cNscesfkiJFIJsHMCm0w/edit?usp=sharing // http://www.internetgeeks.org/tech/add-timestamp-time-stamp-google-docs-spreadsheet/ /*Updated and maintain by internetgeeks.org*/

function onEdit(event) {

 var timezone = "GMT-5";
 var timestamp_format = "MM-dd-yyyy HH:mm"; // Timestamp Format. 
 var updateColName = "location";
 var timeStampColName = "start time";
 var sheet = event.source.getSheetByName('Sheet1') //Name of the sheet where you want to run this script.


 var actRng = event.source.getActiveRange();
 var editColumn = actRng.getColumn();
 var index = actRng.getRowIndex();
 var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues();
 var dateCol = headers[0].indexOf(timeStampColName);
 var updateCol = headers[0].indexOf(updateColName); updateCol = updateCol+1;
 if (dateCol > -1 && index > 1 && editColumn == updateCol) { // only timestamp if 'Last Updated' header exists, but not in the header row itself!
   var cell = sheet.getRange(index, dateCol + 1);
   var date = Utilities.formatDate(new Date(), timezone, timestamp_format);
   cell.setValue(date);
 }

} 199.58.182.107 03:59, November 25, 2017 (UTC)

Community content is available under CC-BY-SA unless otherwise noted.