title: Timestamp a Cell when a Condition is met
body: <p>I'm completely new to scripts so I was wondering if anyone could assist me with the following:<br />
  I have a spreadsheet where Column D has the status of a project, and I would like Column H to populate with the current timestamp/date when Column D is populated with &quot;Completed&quot;.</p>
  <p>If the status changes from Compete to another value, the timestamp should disappear. It's a spreadsheet with multiple users so the timestamp trigger should apply regardless of who the user is.</p>