SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to use text formulas, but I also want to include data in coulmn 'ID'. As this is default column for any list it is not available in default selection. So I have added it manually.

Now old items got updated, but new items are not getting updated for 'ID'. Writing formula I used:

=[First Name]&"/"&[Last Name]&"/"&ID
share|improve this question

migrated from Nov 1 '12 at 17:54

This question came from our site for professional and enthusiast programmers.

This isn't possible in calculated columns because the value of the ID field isn't determined until after the row is inserted into the DB. It works when you create the calculation because when the column is edited, all the calculations are performed all over again.

An out-of-the-box workflow can handle this for you, or an event receiver.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.