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

Occasional Visitor

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

 

0 Replies