title: SharePoint: Calculated Column Values Disappear When Editing List Item. Any ideas?
body: <p>I have a calculated column in a custom SharePoint 2007 list, with the following formula:</p>
  
  <pre><code>=CONCATENATE("IR-",[ID],"-",LEFT(UPPER([Title]),25))
  </code></pre>
  
  <p>If an item is created in the list, everything is fine, however, when an item is updated the [ID] column is no longer in the calculated column for that item.</p>
  
  <p>So, on creation: "IR-40-TheTitleIsHere", but after edit, it is, "IR--TheTitleIsHere".</p>
  
  <p>Anyone have some insight on why this would be happening?</p>