title: Can SharePoint column be changed from date/time to calculated date/time
body: <p>I have a SharePoint list with a column that was originally defined as date/time and has been manually populated with date/time information.  I'd really like to populate this column automatically based on the status of another field changing (e.g. =IF([theStatus]="Closed",[Modified]).</p>
  
  <p>When I edit this date field that I'd like to add the above code, I paste the script into the "Calculated" field and when saving, I get the following error:</p>
  
  <p>The formula contains reference(s) to field(s).</p>
  
  <p>Would be grateful to know if I'm doing something wrong or SharePoint just doesn't allow this type of modification.</p>