Is it possible to create a functionality in Google Sheets where a cell, when modified, automatically displays the date of the edit next to it? This could be achieved using a Google

Question

Is it possible to create a functionality in Google Sheets where a cell, when modified, automatically displays the date of the edit next to it? This could be achieved using a Google

Here is the current code snippet I have:

function onEdit(e) {
  
  var range = e.range;
  var val = range.getValue();
  var row = range.getRow();
  var col = range.getColumn();
  var shift = 1;
  var ss = SpreadsheetApp.getActiveSheet().getRange(row, (col+shift));
  
  if (col == 3){
    ss.setValue(new Date()).setNumberFormat("MM/dd/yyy hh:mm:ss");
  }
  if (val == ""){
    ss.setValue("").setNumberFormat("MM/dd/yyy hh:mm:ss");
  }
}

This describes the current functionality:

https://i.stack.imgur.com/wqqGH.png

https://i.stack.imgur.com/tdZKO.png

However, there seems to be an issue where updating a cell in barcode does not trigger the timestamp update...

javascript google-apps-script google-sheets

Answer 1

Answer №1

function handleInput(event) {
  //event.source.toast("Entry");
  //console.log(JSON.stringify(event));
  const sheet = event.range.getSheet();
  if(sheet.getName()=="Sheet1" && event.range.columnStart==3 && event.value) {
    event.range.offset(0,1).setValue(Utilities.formatDate(new Date(),Session.getScriptTimeZone(),"MM/dd/yyyy HH:mm:ss"));
  }
}

It may not be suitable for all sheets, but it could work well here.

Answer 2

function handleInput(event) {
  //event.source.toast("Entry");
  //console.log(JSON.stringify(event));
  const sheet = event.range.getSheet();
  if(sheet.getName()=="Sheet1" && event.range.columnStart==3 && event.value) {
    event.range.offset(0,1).setValue(Utilities.formatDate(new Date(),Session.getScriptTimeZone(),"MM/dd/yyyy HH:mm:ss"));
  }
}

It may not be suitable for all sheets, but it could work well here.

Is it possible to create a functionality in Google Sheets where a cell, when modified, automatically displays the date of the edit next to it? This could be achieved using a Google

Answer №1

Similar questions

Working with AngularJS's $q promise and socket.io

Making modifications to the database will trigger real-time updates in the web interface. How is it possible to achieve this seamlessly?

What steps should I take to troubleshoot the 'TypeError: userId is not a function' error in my unban feature?

Organizing classes under namespaces in Node.js

Having issues with images not loading and receiving a 401 error with the API while using Vite in a production build

Tips for shrinking a sticky header when scrolling using Angular and JavaScript

Steps to deactivate a JavaScript function once the page has undergone a Page.IsPostBack event

choosing from dropdown menu items

Having trouble accessing a website that is embedded within an iframe, and experiencing issues with several ajax post requests not functioning properly within the iframe specifically on Chrome

Is it possible to check dynamically if a string contains multiple substring matches?

The behavior of Angular 4 CSS and JS changes upon refreshing the page

Ways to verify whether a callback function supplied as a parameter in Javascript has any arguments

What steps should be taken to avoid an event from occurring when an error message is encountered?

Altering styles of a child component within a parent component using material-ui

Transferring information in React from a child component to its parent and then to another child

What are the steps to ensure availability validation with jQuery validation?

Express.js never terminates a session

'jQuery' is not recognized as defined, error no-undef

What is the correct way to activate buttons within a v-for loop in Vue.js?

Is it possible for jquery JSON AJAX to block all users?