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
David Huang 34David Huang 34 

IF formula issue

Hi all,
this must be very easy for many of you.
I'm using process builder to create a Task
Task due date is determined by the Task owner, and Task owner is a lookup field
story:
if task owner is Sarah, then due date is 10/11/2021
if task owner is Justin, then due date is 10/12/2021

how to write this formula, thanks in advance, cheers

David


 
AnkaiahAnkaiah (Salesforce Developers) 
Hi David,

Try with below.

User-added image
  
[Task].owner.user.UserName = Sarah

[Task].owner.user.UserName = Justin

If this helps, please mark it as best answer

Thanks,
Ankaiah
 
David Huang 34David Huang 34
Hi Ankaiah,
Thanks for the quick response.
But sorry I'm after a formula, and where is the due date? cheers

David
David Huang 34David Huang 34
bascially a formula should be
If owner is Sarah, then due date shows 10/11/2021
if owner is Justin, then due date shows 10/12/2021
 
AnkaiahAnkaiah (Salesforce Developers) 
Hi David,

Refer the below screenshot.
User-added image
You need to add two criterias .

Please let me know, if any help required.

Thanks,
Ankaiah
Jayeshkumar ParmarJayeshkumar Parmar

Hi David Huang,

 

Try Below Steps,

First Steps

 

Second Steps

 

Third Steps

 


Same as for Justin.

 

 

If this helps,please mark it as best answer

 

Thanks.
Jayeshkumar ParmarJayeshkumar Parmar

Hi David Huang,

also Ankaiah mentions the formula to achieve this,Use that formula  in process builder and Cheers.

[Task].owner.user.UserName = Sarah

[Task].owner.user.UserName = Justin
David Huang 34David Huang 34
sorry guys I didn't explain myself clear, which wasted your time, here is the process I made,User-added image

Its on Imediate Actions--> create a Task.
field is Due date, determined by who the own is: If owner is Sarah, then due date shows 10/11/2021
                                                                             if owner is Justin, then due date shows 10/12/2021
I know the workaround but atm, I want to know if there is a formula that I can use, cheers

David
AnkaiahAnkaiah (Salesforce Developers) 
Hi David,

use the below conditions.

write two immediate updates.

update1: [Task].owner.user.UserName = Sarah
update2: [Task].owner.user.UserName = Justin



User-added image