+ Start a Discussion
amish.jainamish.jain 

logic for comparing 4 fields in Pardot

I have 4 dail out fields (Dial 1, Dial 2, Dial 3, Dial4) having Data type as Date/Time. These field type are being used by Inside Sales Rep. for reaching out to Prospect. Everytime they dial out to Prospect dial out is recoreded subsequently. 

Pardot Last Activity, is another field I am using to track last activity by any prospect. Now, I wanted to know if my inside sales rep. have dialed to them after Prospect last visit. 

((NOW() - pi__last_activity__c) ) - 

MIN( (NOW() - Cold_Call_1__c),(NOW() - Cold_Call_2__c) , (NOW() - Dial_out_3__c ),(NOW() - Dial_out_4__c ))

I used above logic to find out nearest date & substracted it from Pardot last activity, but if any of the dial out is blank then this logic dosen't work. For above logic to work all 4 dial field shouldn't be Blank. 

Please guide me on how to include blank fields also in this formula or logic

Thanks