0

Is there a way to have google sheets auto populate a comment based on specific entries in a cell? I am trying to have google sheets auto populate a google form response if certain content is entered into a cell in google sheets.

2
  • 2
    Welcome to Web Applications. What do you mean by "auto populate a comment"? Are referring to value to a cell or to emulate doing a right click over a cell and selecting Comment in the emerging menu? Also please add a brief description of your search efforts as is suggested in How to Ask.
    – Rubén
    Nov 12 at 16:07
  • Hi and welcome. I can't foresee a built-in function providing an answer to this - it'll be a script I'm afraid. There's some discussion about comments here Google Apps Script Spreadsheet Comment Automation (read all the answers and comments - the situation has changed over time). The long and the short is that you can't add "comments" per se without a lot of effort BUT you can add a note with setNote(note) Doc ref.
    – Tedinoz
    Nov 12 at 22:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.