Forum Discussion
SharePoint List: Calculated (calculation based on other columns) error
Hi all. Nice to connect with you.
I have a question related to SharePoint List. In column "Idea ID", I tried to create a calculated column based on column "ID", overall the formula is working, but there are 1 or 2 rows when the formula does not work (refer to picture above), the ID number is missing. I have no idea what the issue or problem is. Do you know why this situation happened? How to solve the issue?
Formula that I created--> ="APAC-"&Region&"-CI-"&ID (ID is referring to ID that generate automatically by SharePoint List)
Picture:
3 Replies
Hi anggefernando_ ,as I remember, there was an issue with a calculated column using a formula that references the ID column.
The solution was provided by ganeshsanap in a different post. Check this link
-> Re: Using the ID column to generate a number in a calculated column. - Microsoft Community Hub
Here is Microsoft official documentation for same: Introduction to SharePoint formulas and functions
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
- Hi,
I have the same issue. Have you been able to solve it ? Can you please let me know how you fixed it?
