Stump the Panel » Site Managers and Site Collection Managers

Concatenated column issue

(3 posts)

  1. mparter
    Member

    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".

    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.

    Posted 2 days ago #

  2. Christophe
    Member

    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:
    http://pathtosharepoint.wordpress.com/2008/08/07/calculated-columns/

    A workaround would be to use a workflow that will duplicate the ID in another column.

    Posted 2 days ago #

  3. CGlaves
    Member

    Agreed! I began to use the ID column in calculated columns and was presented with all sorts of issues.

    Posted 1 day ago #

RSS feed for this topic

Reply

You must log in to post.