http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Thu, 26 Feb 2009 23:25:37 +0000 http://www.endusersharepoint.com/STP/topic/concatenated-column-issue#post-4515 Mon, 23 Feb 2009 15:25:45 +0000 CGlaves 4515@http://www.endusersharepoint.com/STP/ <p>Agreed! I began to use the ID column in calculated columns and was presented with all sorts of issues. </p> http://www.endusersharepoint.com/STP/topic/concatenated-column-issue#post-4480 Sun, 22 Feb 2009 23:30:47 +0000 Christophe 4480@http://www.endusersharepoint.com/STP/ <p>You should no use the ID field in a calculated column. See a list of limitations with calculated columns at the end of this post:<br /> <a href="http://pathtosharepoint.wordpress.com/2008/08/07/calculated-columns/" rel="nofollow">http://pathtosharepoint.wordpress.com/2008/08/07/calculated-columns/</a></p> <p>A workaround would be to use a workflow that will duplicate the ID in another column. </p> http://www.endusersharepoint.com/STP/topic/concatenated-column-issue#post-4477 Sun, 22 Feb 2009 16:53:43 +0000 mparter 4477@http://www.endusersharepoint.com/STP/ <p>I'm concatenating two columns in a task list, ID and Title (CONCATENATE(ID, ": ", Title). This appeared to have worked fine until recently. Now, the ID isn't included so the column just contains ":Title".</p> <p>I can temporarily "fix" this by editing the column and clicking OK as it must force a re-calculation, however this isn't a sustainable solution longer-term. </p>