function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Sudhir_MeruSudhir_Meru 

Workflow Condition Not Working

Hi,

 

  I made a email alter when work flow condition is set as mentioned below. 

 

  In Lead there is a Column called Lead Status  When lead status is changed to MQL or SQL it must trigger email to User. 

 

   I tried with Operator Contains(MQL, SQL) its not working,  But when i mention equal to MQL or SQL it is working. 

 

  Please suggest me how to add this condition. 

 

Thanks

Sudhir

Best Answer chosen by Admin (Salesforce Developers) 
nbknbk

Hello,

 

Can you try with below condition in workflow rule.

OR(
ISPICKVAL(Lead Status, "MQL"),
ISPICKVAL(Lead Status, "SQL")
)

 


please have a look below url for more details.

https://success.salesforce.com/questionDetail?qid=a1X30000000J5xDEAS

 

Thanks,

Krishna

All Answers

AsiereikiAsiereiki

use "equal" and "MQL,SQL"

 

 

Sudhir_MeruSudhir_Meru

Hi,

 

  Thanks for your reply, I am not using foruma, I am using Rule Criteria are Met from Pick list. Tried with your suggestion

 

   Selected equals (SQL , MQL ) still email alter is not woring. If i give only one email alter is getting triggered. 

 

Thanks
Sudhir

AsiereikiAsiereiki

ahh!! okok!

 

you need to use "include" in the operator. not include, not equals.

 

Hope it helps

Sudhir_MeruSudhir_Meru

Do you want me to use Include Opertator. I tried giving (SQL , MQL ) it is throwing error

AsiereikiAsiereiki

Hi again,

 

I have the solution.

 

Make 2 conditions, one "equals SQL" and other "equals MQL" and click in the link of "add filter logic".  then, make an OR between this two conditions. that will work! :)

Sudhir_MeruSudhir_Meru

Hi, 

 

 Thank you for you reply, I tried your logic still its not working but if i give one condition equal "MQL" it works. 

AsiereikiAsiereiki

You are doing something wrong, because if it works with one condition, it works with 2 conditions with an OR.

 

Are you sure the rule is active? the email alert is well configurated?

nbknbk

Hello,

 

Can you try with below condition in workflow rule.

OR(
ISPICKVAL(Lead Status, "MQL"),
ISPICKVAL(Lead Status, "SQL")
)

 


please have a look below url for more details.

https://success.salesforce.com/questionDetail?qid=a1X30000000J5xDEAS

 

Thanks,

Krishna

This was selected as the best answer
Sudhir_MeruSudhir_Meru

Rule is Active, I tried the same condition added two condition with OR logical operator. Dnt know what is wrong with my condition. it works only when one equal to condition is provided. 

 

  Please provide if alternative foruma we can use

AsiereikiAsiereiki

But some error shows when you try to create the rule? or the mail is not sended?

Sudhir_MeruSudhir_Meru

Hi Krishna, 

 

   Thank You for your suggestion you method is working. But one bug is When i change from MQL to SQL or SQL to MQL. Email is not getting triggered. Other than that from any other pick list value to MQL or SQL E-Mail is getting triggered. 

 

  Please suggest me how to fix this issue. 

 

Thanks
Sudhir