SharePoint List: Calculated (calculation based on other columns) error

Copper Contributor

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:

anggefernando__0-1647051501196.png

 

3 Replies
Hi,
I have the same issue. Have you been able to solve it ? Can you please let me know how you fixed it?

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

@michalkornet @anggefernando_ 

 

Here is Microsoft official documentation for same: Introduction to SharePoint formulas and functions  

ganeshsanap_0-1719200175522.png


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.