Sign Up ›

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

Formula Not Working

AND(PRIORVALUE( pi__score__c )< pi__score__c - 25, Lead_Record_Type_Text__c = "School Lead", OR(LastActivityDate < TODAY() +5, LastActivityDate=null) )

Can someone help me with this formula. It worked until I added the syntax ' , OR(LastActivityDate > TODAY() +5, LastActivityDate=null)'. I'm trying to say the last activity date has to be greater than today+ 5 days OR equal to blank.
 

Thanks for the help!

Madhura BMadhura B
Hi Eric,

Your formula has LastActivityDate < TODAY() +5 whereas in the description you say you are checking the last activity date to be greater than today + 5. Can this be the reason? 


Thanks
Eric BollerEric Boller
Sorry, either way though once I add that last syntax it doesn't work. Whether or not it is < or >.
Eric BollerEric Boller
Actually it seems like some notifcations are sent out with the below formula, but it doesn't appear to be working properly.

AND(PRIORVALUE( pi__score__c )< pi__score__c - 25, Lead_Record_Type_Text__c = "School Lead", OR(LastActivityDate < TODAY() +5, LastActivityDate=null) )
Blessy Voola 4Blessy Voola 4
Hi Eric,

Just replace LastActivityDate=null with ISBLANK(LastActivityDate)

This should work.

Thanks!