I have a calculated column in a Sharepoint list that references and displays the 'ID' field, called 'Issue ID', see below:

enter image description here

This seems to work fine until someone updates a ticket - at which point it seems this field then changes to 0:

enter image description here

Does anyone know what is causing this? Any thoughts on how I retain the ID number for each record in this field?

Thanks in advance.

1 Answer 1


Using the ID column in calculated columns is not supported, this is why it doesn't appear in the "Insert Column" list next to the formula box. Alternatively, you could use a Power Automate flow that runs on the creation of a new item to update a column using the ID column.

  • Thank you. Seems like a strange gap in functionality here. I appreciate your help, nonetheless.
    – user96941
    Apr 20, 2021 at 22:01
  • If you think the answer has helped, please upvote or mark the answer as accepted to the let the community know :) Apr 20, 2021 at 22:02

Your Answer

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

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