title: Automatic timestamp when a cell is filled out
body: <p>I have an excel formula that is very simple and it works because I can restrict the recursive iterations.  I am not very script savvy, but this is what it is and it works.</p>
  
  <p><code>=IF(D24="P",IF(E24="",DateStamp,E24),IF(D24="F",IF(E24="",DateStamp,E24),""))</code></p>
  
  <p>Its a pass/fail testing sheet and it adds a timestamp when someone passes or fails the test.  We've added a few more people and I want to move the document to google apps to allow more than 1 person to work on it at the same time.</p>
  
  <p>The only issue i've come in is the circular reference that this causes.  In excel I can limit the # of iterations in the options, I dont have this ability anymore.  Any help would be great.</p>
  
  <p>EDIT:  What I've tried.
  I've tried to find a way to input a VBA Script that a coworker created that would work for me.  I'm not good with scripting so I'm unable to make this into a google apps script: </p>
  
  <p>VBA SCRIPT:</p>
  
  <pre><code>    Private Sub Worksheet_Change(ByVal Target As Range)
  
  If Target.Column = 4 Then
  If Cells(Target.Row, 5).Value = "" Then
  
  Cells(Target.Row, 5).Value = Now
  End If
  Else
  End If
  
  
  End Sub
  </code></pre>
  
  <p>In theory I tried to create a script that will copy a cell that has a timestamp on it and then try to 'paste special' and just paste the value into the cell needed.  This would work except I was unable to find a way to paste special with the google apps scripting.</p>
  
  <p>Thanks for any help
  /edit</p>