You need to sign in to do that
Don't have an account?
RoxyGirl
Need help with formula please!!
I know this should be simple but for some reason I cant get it to work.
The syntax checker keeps telling me that the last 3 on the opp owner id are "extra"
I am trying to set up an email workflow rule to send an email when opportunities with specific owners have the close date changed. Here is what I have
OwnerId =xxxxxxxxxxxxxxx OR Ownerid = xxxxxxxxxxxxxxx OR Ownerid = xxxxxxxxxxxxxx OR Ownerid = xxxxxxxxxxxxxxx AND ISCHANGED(CloseDate )
Thanks in advance
Kylet is right on spot.
The following is in the ischanged function help.
This function is available only in:
Is your Every time a record is created or edited trigger type turned on?
All Answers
We are not yet using Workflow, but I am assuming that the formulas work the same there as in other formula situations.
You will want to put quotes around the ownerid # and use || for or and && for and.
I also recommend when using or and and statements in the same formula, using parathesis to definitely indicate to the program what you want to do first. A math example of this would be 1 + 2 * 5. Do I want 1 + 2 then multiply five (15) or 2 * 5 then add 1 (11). It probably would not make a difference in the result of this formula but habits such as these can really save headaches in more convoluted formulas.
(OwnerId ="xxxxxxxxxxxxxxx" || OwnerId ="xxxxxxxxxxxxxxx" || OwnerId ="xxxxxxxxxxxxxxx" || OwnerId ="xxxxxxxxxxxxxxx") && ISCHANGED(CloseDate)
Thank you for your reply, your solution eliminated the errors I was getting but now it is telling me that I cannot use ISCHANGED in the formula. Do you have any ideas on how to return the results I need without using the ISCHANGED?
Thanks too for the info to keep in mind when creating formulas, that will be most helpful in the future.
You need to evaluate the rule "Every time a record is edited or created" in order to use ISCHANGED
Kylet is right on spot.
The following is in the ischanged function help.
This function is available only in:
Is your Every time a record is created or edited trigger type turned on?
That worked - Thanks!!!!!!