How to Show Last Activity Date on Account Page?

Question

When running an Account report, I can include a field called “Last Activity Date.” However, when I try to add this field to the Account detail page, it doesn’t appear as an option. I checked profile permissions but couldn’t find any related settings. While I found documentation explaining how the field is populated, I haven’t seen anything about why it wouldn’t be available on the detail page.

Is there a way to display the Last Activity Date field on the Account detail page?

Answer:

Yes, you can display the Last Activity Date on the Account detail page by creating a formula field, as the field is available via the API and Reports but not in the standard UI.

To create a custom formula field that displays Last Activity Date, follow these steps:

1. Go to Setup.
2. Navigate to Object Manager and select Account (or any object where you want to display this field).
3. Click on Fields & Relationships and then click New.
4. Select Formula as the data type and click Next.
5. Enter a Field Label of your choice and set the Formula Return Type to Date, then click Next.
6. In the formula editor, click on Advanced Formula and then Insert Field.
7. Locate and select Last Activity Date (API Name: LastActivityDate) and insert it into the formula.
8. Your formula should look like this:

LastActivityDate  

9. Click Check Syntax to ensure the formula is valid.
10. Click Next, set the field-level security as needed, and add the field to the Page Layout.
Click Save.
Now, the Last Activity Date will be displayed on the Account detail page, allowing you to track it directly without needing a report.

This method works for other objects as well, such as Leads, Contacts, or Opportunities. If you need the field on multiple objects, repeat the same process for each.

Real-Time Project-Based Salesforce Training to Kick Start Your Career

Our Salesforce Course is designed to provide a thorough understanding of the Salesforce platform, equipping you with the essential skills to thrive in the CRM industry. The curriculum includes vital modules such as Salesforce Admin, Developer, and AI, combining foundational knowledge with hands-on practice. By engaging in real-world projects and assignments, you’ll develop the expertise to address complex business challenges using Salesforce solutions. Our expert instructors ensure you gain both technical skills and industry insights necessary for success in the Salesforce ecosystem.

Along with technical knowledge, our Salesforce training in Kota offers personalized mentorship, exam preparation, and interview coaching to enhance your career prospects. You’ll have access to comprehensive study materials, live project experience, and dedicated support throughout your learning journey. Upon completing the course, you’ll be well-prepared for certification exams and equipped with the practical skills employers value. Begin your Salesforce career with us and unlock countless career opportunities. Sign up for a Free Demo today!