title: Archer GRC: Calculate current date when values list changes
body: <p>I need assistance with a calculation that will set a date field (Respondent Status Date Change) to the current date each time values list (Respondent Status) has a change in value:</p>
  
  <p><a href="https://i.stack.imgur.com/CCClQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CCClQ.png" alt="Status values list and Date field"></a></p>
  
  <pre><code>IF(
  VALUEOF([Respondent Status],"Pending Assignment"),VALUEOF([Respondent Status],"Work in Progress"),VALUEOF([Respondent Status],"Escalated to ERD"),VALUEOF([Respondent Status],"Questions to Risk Group"),VALUEOF([Respondent Status],"Optimization Opportunity"),VALUEOF([Respondent Status],"Completed"),VALUEOF([Respondent Status],"No Selection")))
  NOW(),
  </code></pre>