Loading
Salesforce now sends email only from verified domains. Read More

Salesforce Reports Automatically Use the 18-Character Record ID When Filtering by Record ID

Publish Date: May 4, 2026
Description

When adding a filter to a Salesforce report using a record's Salesforce ID, entering a 15-character ID will automatically convert it to the full 18-character version once the filter is applied. For example, if you enter the 15-character ID "001ABC123DEF456", Salesforce automatically converts it to the 18-character case-safe version "001ABC123DEF456GHI" when the filter is saved. This is expected behavior in Salesforce reports.

Resolution

Salesforce report filters internally use the 18-character record ID format, also known as the case-safe ID. The report user interface displays only the 15-character ID in the column view. Both IDs refer to the same record, and the automatic conversion to 18 characters is by design.

How to Display the 18-Character Record ID in a Report

If you need to display the full 18-character Record ID as a column in your report, you can create a Formula field on the object:

  1. Navigate to Setup and open the Object Manager for the relevant object (for example, Account or Contact).
  2. Select Fields and Relationships, then click New.
  3. Select Formula as the field type and click Next.
  4. Give the field a label such as "18-Character Record ID" and set the return type to Text.
  5. In the formula editor, enter the following formula: CASESAFEID(Id)
  6. Save the field.
  7. Add the new formula field as a column in your report to display the 18-character Record ID.
Additional Resources

To convert 15 - character ID to 18 - character ID, please refer the below article:

https://help.salesforce.com/s/articleView?id=000385066&type=1

Knowledge Article Number

005131264

 
Loading
Salesforce Help | Article