Has Activity Formula

It can sometimes be useful to know whether a call or task has been logged since assignment. Salesforce includes a standard field called LastActivityDate which gives the date of the most recent activity. We can use this to create a formula for determining whether an activity has been logged since assignment.

If( LastActivityDate > DATEVALUE(n2de__Last_distributed__c), True, False)  

More details on the LastActivityDate field here 

How did we do?

Timezone Bucket Formula

Territory Formula

Contact