Good question here. How about something like this? I have the script below functioning so whenever a new row is added to Sheet2, the timestamp is automatically inserted into column A of that row.


function onEdit(e) {
var range = e.range;
var sheet = range.getSheet();

// Check if the edited range is in Sheet2 and the timestamp column
if (sheet.getName() == "Sheet2" && range.getColumn() == 2) { // Assuming the timestamp column is column B
var row = range.getRow();
var timestampCell = sheet.getRange(row, 1); // Assuming the timestamp should be in column A
if (!timestampCell.getValue()) { // Check if timestamp is not already set
timestampCell.setValue(new Date());
}
}
}


Sure! Use an “onformsubmit” instead of “onedit”.


function onFormSubmit(e) {
var sheet = e.range.getSheet(); // Get the sheet where the form data is submitted
var user = Session.getActiveUser().getEmail(); // Get the email of the user who submitted the form
var timestamp = new Date(); // Get the current timestamp
var row = e.range.getRow(); // Get the row where the form data is submitted

// Set the timestamp and user email in the corresponding cells
timestampCell.setValue(timestamp); // Set the timestamp in column B
userCell.setValue(user); // Set the user email in column C
}


Just add in an “onedit” into the scrip. Here’s how it might look:

function onEdit(e) {
var range = e.range; // Get the edited range
var sheet = range.getSheet(); // Get the edited sheet
var user = Session.getActiveUser().getEmail(); // Get the email of the user who made the change
var timestamp = new Date(); // Get the current timestamp

// Check if the edited range is in a specific sheet and range
if (sheet.getName() == "Sheet1" && range.getColumn() == 1 && range.getRow() >= 2) {
var timestampCell = sheet.getRange(range.getRow(), 2); // Get the cell in the same row, but column B for timestamp
var userCell = sheet.getRange(range.getRow(), 3); // Get the cell in the same row, but column C for user email
timestampCell.setValue(timestamp); // Set the timestamp in column B
userCell.setValue(user); // Set the user email in column C
}
}


No problem! That’s a rare use case, but there’s a workaround. To add time stamps offline, use the onEdit trigger to automatically add a timestamp when a cell is modified. This trigger will work even when offline, but the changes will be applied once the spreadsheet regains an internet connection.

Here’s a simplified example of a script:
function onEdit(e) {
var sheet = e.source.getSheetByName('YourSheetName');
var range = e.range;
var timestampColumn = 2; // Adjust the column index where you want the timestamp

if (range.getColumn() !== timestampColumn) {
sheet.getRange(range.getRow(), timestampColumn).setValue(new Date());
}
}


Try something like:
=IFERROR(INDEX($A$2:$A$100, SMALL(IF($C$2:$C$100<>0, ROW($C$2:$C$100)-ROW($C$2)+1), ROW(1:1))), "")


You can do this with an App Script:

function onEdit(e) {
var sheet = e.source.getSheetByName('YourSheetName'); // Replace 'YourSheetName' with your actual sheet name
var range = e.range;

// Stamp the current date in the column next to the username
sheet.getRange(range.getRow(), 3).setValue(new Date());
}
}


You can dynamically generate a timestamp and include it in the title of your PDF document.

Try this:
function convertSheetToPDFAndEmail() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet = spreadsheet.getSheetByName('YourSheetName'); // Replace 'YourSheetName' with the actual sheet name
var range = sheet.getDataRange();
var data = range.getValues();
var urlColumnIndex = 1; // Adjust this to the column index where image URLs are located

// Fetch all image URLs
var imageUrls = [];
for (var i = 1; i < data.length; i++) { var imageUrl = data[i][urlColumnIndex - 1]; // Adjust to 0-based index imageUrls.push(imageUrl); } // Create a temporary folder var folder = DriveApp.createFolder('TempFolder'); // Fetch and resize images var images = []; for (var i = 0; i < imageUrls.length; i++) { var imageUrl = imageUrls[i]; var imageBlob = UrlFetchApp.fetch(imageUrl).getBlob(); var resizedBlob = resizeImage(imageBlob, 200, 200); // Adjust the width and height as needed var imageFile = folder.createFile(resizedBlob); images.push(imageFile.getBlob()); } // Create a temporary sheet for PDF conversion var tempSheet = spreadsheet.insertSheet('TempSheet_' + timestamp); // Include timestamp in the sheet name tempSheet.getRange(1, 1, data.length, data[0].length).setValues(data); // Insert resized images into the temporary sheet for (var i = 0; i < images.length; i++) { tempSheet.insertImage(images[i], 1, data.length + i + 1); // Adjust column index } // Convert the temporary sheet to PDF var pdf = folder.createFile(tempSheet.getAs('application/pdf').getBytes()); // Email the PDF to the user MailApp.sendEmail({ to: 'user@example.com', // Replace with the recipient's email address subject: 'PDF_with_Images_' + timestamp, // Include timestamp in the subject body: 'Please find the attached PDF with images generated on ' + timestamp + '.', attachments: [pdf] }); // Clean up: Delete the temporary folder and sheet folder.setTrashed(true); spreadsheet.deleteSheet(tempSheet); } function resizeImage(blob, width, height) { var base64 = Utilities.base64Encode(blob.getBytes()); var resizedBase64 = Utilities.base64EncodeWebSafe(Utilities.newBlob(Utilities.base64DecodeWebSafe(base64)).getResize(width, height).getBytes()); return Utilities.newBlob(Utilities.base64DecodeWebSafe(resizedBase64)); }

function onEdit() {

var s = SpreadsheetApp.getActiveSheet();

if( s.getName() == “Sheet1″ ) { //checks that we’re on Sheet1 or not

var r = s.getActiveCell();

if( r.getColumn() == 1 ) { //checks that the cell being edited is in column A

var nextCell = r.offset(0, 1);

if( nextCell.getValue() === ” ) //checks if the adjacent cell is empty or not?

nextCell.setValue(new Date());

}

}

}