I need to keep the URL of a list item to use in a notification so I have a formula that looks like this:


When I create an item in the list, in this case item 24, the column is formatted correctly as:


But when I go into the list item and edit some other attribute, say the status, the URL is now:


The item id, 24, has been dropped. If I go check the formula it is now:


The brackets have been dropped from the formula.

Any ideas on what is going on and how to prevent?

1 Answer 1


You can't use the ID in a calculated column. You can try using a workflow to build a dynamic string and set a text field with the value you require.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.