title: How can I change the value of the cell A2 to "Today()" when I make any change in the cell A1?
body: <p>I am doing my project management in a Google Spreadsheet. A script that automates changes in my comment field to my change_date-field =TODAY() would help me to save some time and also use this function for other scripts I might need in the future.</p>
  
  <p>When I make changes in a comment-field currently, I have to manually enter the change date in my change_date-field which is something that could be easily automated, I think.</p>
  
  <p>Unfortunately I have no clue how to write the code for this.</p>
  
  <p>When I am making any changes in my column named "comment" I want to return the value "=TODAY()" in the column named "change_date". Can you guys help me out with a script that does this job for me automatically?</p>