You need to sign in to do that
Don't have an account?
Eric 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")
IF(OR(ISBLANK(LastActivityDate), LastActivityDate < (TODAY()-30)), "No", "In Window")
bob_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.