function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Adeline MooreAdeline Moore 

Process Builder need formula help please?

So my process creates a completed task when a lead get generated, but my formula is written incorrectly. I need the task to only happen when the lead is only requesting   Canis Major/Canis Minor Program. 

User-added image
User-added image

Can someone help me write the formula please??


Thank you Adeline
Maharajan CMaharajan C
Some Questions are below : 

What is the Field Name?

Would you also like to check the Lead Email is blank or not?

Thanks
Adeline MooreAdeline Moore
@maharaja C

I do want the code for blank email in there.

I also need the "requested" field to only be  Canis Major/Canis Minor Program
Maharajan CMaharajan C
Hi Adeline:

Please use the below formula:

NOT(ISBLANK([Lead].Email)) && ISPICKVAL([Lead].requested,'Canis Major/Canis Minor Program')

If Requested is custom field means then please append the ( __c  ) in the end of field name in formula i.e requested__c . 

Can you please let me know if it works or not!!!

Thanks