cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Formula with two Or and one And not working

Jump to solution

This formula is not working for this requirement: only displays if Request Type=Add New Supplier OR =Activate Supplier AND Vendor Confirmation Button=Yes:

 

not(equals(Request_Type, 'Add New Supplier')||(equals(Request_Type, 'Activate Supplier') &&equals(Vendor_Confirmation_Button, 'Yes'))

 

It was working without the part after ‘||’ .  Once I added the 2nd condition after ‘||’, this control is displayed regardless the value in “Vendor Confirmation Button”.

 

It seems that the condition after ‘&&’ is ignored.

 

I also tried this way and it also not working:

 

and(equals(Vendor_Confirmation_Button, 'Yes')), not(equals(Request_Type, 'Add New Supplier')||equals(Request_Type, 'Activate Supplier'))

Labels: (1)
Tags (1)
0 Kudos
Reply
2 Replies
Workflow Hero

Re: Formula with two Or and one And not working

Jump to solution

I got this to work:

not(or(equals(Request_Type, 'Add New Supplier'), equals(Request_Type, 'Activate Supplier'))&&equals(Vendor_Confirmation_Button, 'Yes'))

It's just matter of enclose components properly, 'Not' negates everything enclosed

0 Kudos
Reply
Workflow Hero

Re: Formula with two Or and one And not working

Jump to solution

Thanks for sharing.

0 Kudos
Reply