Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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 stackoverflow.com Nov 1 '12 at 17:54

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

1 Answer 1

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

 
discard

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