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)