How to Convert 15 Digit ID to 18 in Salesforce

Quick summary

In Salesforce, 15-digit IDs are case-sensitive and can cause errors in integrations and reports; converting them to 18-digit IDs using a formula field ensures reliable, case-insensitive record references. This tutorial walks through creating a Formula field in the Object Manager via Advanced Setup to output the full 18-character ID.

Steps

1. Click the gear icon at the top-right of your Salesforce dashboard to open the setup menu.
2. Select Open Advanced Setup from the dropdown.
3. Click Object Manager at the top of the Setup page.
4. Select an object from the list to open it.
5. Select Fields & Relationships from the left-hand sidebar.
6. Click New at the top to start creating a new field.
7. Choose Formula as the Data Type for the new field.
8. Select Text as the Formula Return Type.
9. Enter or paste the 18-digit ID conversion formula into the Formula text box.
10. Review the field details, then click Next to proceed.
11. Review the details again, then click Save to create the field.