• Katie Paetz 5
  • NEWBIE
  • 0 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
Hello,

I'm trying to write a criteria formula in process builder that if true will send an email 168 days prior to field trip date and if false will not send the email but go to the next criteria. I also have other criteria like a status and checkbox field. 

So far I have:
ISPICKVAL([Field_Trip_Request__c].Status__c, "Trip Approved") &&
[Field_Trip_Request__c].Exclude_from_Email_Automation__c = FALSE &&
TODAY() + 168 >= [Field_Trip_Request__c].Field_Trip_Date__c 

Is this possible? What am I doing wrong?  Thanks for your help!