0

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.

Improve this question

1 Answer 1

Reset to default
0

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.

Improve this answer
2
  • Thank you. Seems like a strange gap in functionality here. I appreciate your help, nonetheless. Commented 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 :) Commented Apr 20, 2021 at 22:02

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.