function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Eric BollerEric Boller 

Last activity by owner

How can I create a field that measures the last activity of the lead owner? I currently have the below but that measures any activity.

IF(OR(ISBLANK(LastActivityDate), LastActivityDate < (TODAY()-30)), "No", "In Window")
bob_buzzardbob_buzzard
I don't think you'll be able to do this with a formula field.  The LastActivityDate is a system provided field on the record, so you can't alter it to restrict to the activities of a single user.  I reckon you'll need to write a trigger for this.