You need to sign in to do that
Don't have an account?
Kumar Singh 2
Help Wit Formula
Hi,
I'm creating a Workflow rule. My requirement is to send an email when the criteria and formula meet.
Whenever a new Lead is created and Lead Stage =Marketing Qualified or Lead owner is edited. It will trigger an email.
My Formula:AND(
Text(Status)= 'Marketing Qualified',
OR(isChanged(OwnerId), isChanged(Status), isChanged(Number_of_Form_Submissions__c), isNew())
)
Please any one help me on this.
Thanks
Vivek
See, ISCHANGED(Status) or any field does not work during the record creation, since you are giving the values for the field 1st time.
So, when ISNEW() is there ISCHANGED will give you false and hence AND condition will fail.
So, the below could help for your scenarion
ISNEW() && ISPICKVAL(Stage,'Marketing Qualified')
Since when the record is new ISCHANGED(OwnerId) will false always and hence no use of using this.
ISNew() will be true only during the record creaion and if some edits the records this workflow will not fire.
Hope this helps.
Thank You,
Rajesh Adiga P.
1. Email should fire for Lead owner when a new lead is being created
2. Email should fire for Lead owner when the status is changed to MQ
3. Email should fire for updated Lead owner when the owner is changed
...???
I believe you are using the STD Lead Status field with value 'Marketing Qualified.
Hope this helps for you.
Thank You,
Rajesh Adiga P.