title: Create automatic timestamp when adjacent cell has specific value
body: <p>I am trying to create a snazzy to do list in Excel. I want to automatically generate a time stamp in column I when column K (in the same row) is equal to 1. </p>
  
  <p>The only suggestions I can find are timestamps that are generated when ANY changes are made, not a specific value entered.</p>
  
  <p>Here's an example of what I want to do based on a google apps question:</p>
  
  <p><a href="https://stackoverflow.com/questions/14390558/add-timestamp-in-adjacent-cell-when-cell-equals-a-specific-value">Add timestamp in adjacent cell when cell equals a specific value</a></p>