Automatic timestamp when a cell is filled out

by

Stackoverflow is a place to ask questions related to programming, e.g. that you’re actually working on. Not really asking for others to develop it for you, i.e. you didn’t even started trying any Apps Script code yet. I recommend you reading its tutorials and guides. It’s really easy to start.

Anyway, just to help you get started, I’ll drop everything you said and stick to the question title: “automatic timestamp when a cell is filled out”

I advise you to do it all on apps script, and drop your formulas entirely, e.g.

function onEdit() {
  var s = SpreadsheetApp.getActiveSheet();
  if( s.getName() == "Sheet1" ) { //checks that we're on the correct sheet
    var r = s.getActiveCell();
    if( r.getColumn() == 4 ) { //checks the column
      var nextCell = r.offset(0, 1);
      if( nextCell.getValue() === '' ) //is empty?
        nextCell.setValue(new Date());
    }
  }
}

This code does what I understood from yours, which is: if something is edited on column D and column E is empty, add the current date to E.

More Related Contents:

  1. How do you create a “reverse pivot” in Google Sheets?
  2. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  3. Create Google Calendar Events from Spreadsheet but prevent duplicates
  4. How do I make a Sidebar display values from cells?
  5. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  6. Apps Script: how to get hyperlink from a cell where there is no formula
  7. Retrieving Google Sheets cell border style programmatically
  8. Determining the last row in a single column
  9. Cannot find method getRange(number,number)?
  10. How do I add formulas to Google Sheets using Google Apps Script?
  11. Deleting rows in google sheets using Google Apps Script
  12. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  13. Adding Buttons To Google Sheets and Set value to Cells on clicking
  14. How to replace text in Google Spreadsheet using App Scripts?
  15. Custom function throws a “You do not have the permission required to setValue” error
  16. Margins parameters for Google spreadsheet export as PDF
  17. Script to convert .XLSX to Google Sheet and move converted file
  18. Hidden field in a Google Form
  19. onEdit() doesn’t catch all changes
  20. Google Sheet use Importxml error could not fetch url [duplicate]
  21. Converting .xls to google spreadsheet in google apps script
  22. Use script in all spreadsheets
  23. How to make onEdit() trigger function apply to multiple sheets
  24. Iterate over range, append string to each
  25. Can the google spreadsheet ‘query’ function be used in google apps script?
  26. How to pause App Scripts until spreadsheet finishes calculation
  27. Custom Functions and Recalculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment