Google Apps Script Spreadsheet Comment Automation

by

There is no way to manipulate Comments via Spreadsheet Services – see Issue 36756650. (Star it if you wish.)

Instead, all the “Comments” methods work on Notes.

The following method will append a new “Modified” timestamp to any existing one – not quite as nice looking as an actual Comment would be, unfortunately.

function onEdit() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var cell = sheet.getActiveCell();
  var comments = cell.getComment();
  // Newline works in msgBox, but not in Note.
  comments = comments + "\\nModified: " + (new Date());
  //Browser.msgBox(comments);
  cell.setComment(comments);
}

More Related Contents:

  1. Refresh data retrieved by a custom function in Google Sheet
  2. Convert column index into corresponding column letter
  3. Create Google Calendar Events from Spreadsheet but prevent duplicates
  4. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  5. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  6. Google Spreadsheet Script – How to Transpose / Rotate Multi-dimensional Array?
  7. Determining the last row in a single column
  8. Cannot find method getRange(number,number)?
  9. How to copy a row from one google spreadsheet to another google spreadsheet using google apps script?
  10. Emailing Google Sheet range (with or without formatting) as a HTML table in a Gmail message
  11. How to download single sheet as PDF to my local device directly (not export to Google Drive)?
  12. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  13. Adding Buttons To Google Sheets and Set value to Cells on clicking
  14. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  15. Synchronize independent spreadsheet rows, filled by IMPORTRANGE()
  16. Export Single Sheet to PDF in Apps Script
  17. How to Autofill last row with formula, when data is received from IFTTT on the last row?
  18. Custom function throws a “You do not have the permission required to setValue” error
  19. Margins parameters for Google spreadsheet export as PDF
  20. How to fix ‘TypeError: Cannot call method “getRange” of null’ in Google Apps Script
  21. Google Apps Script: Dynamically creating spreadsheet menu items
  22. How to run certain scripts under the authority of a specific user?
  23. Set anonymous/dynamic functions to Menu
  24. Script to convert .XLSX to Google Sheet and move converted file
  25. How do you do block comments in YAML?
  26. Hidden field in a Google Form
  27. Apply multiple font colors to the text in a single Google Sheets cell
  28. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  29. Google spreadsheet “Cannot call method “getRange” of null”
  30. Is it possible to create macro buttons to navigate in Google Sheets?

Leave a Comment