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
geis6geis6 

Case formula for workflow - Help needed

Help!  I can't seem to figure out why this formula is not working.  I'm using it in a workflow rule on the case object.

AND(
(OR
(Account.Id = 0017000000Mwwnx),
(Account.Id = 0017000000Mwwao),
(Account.Id = 0017000000MwwPs),
(Account.Id = 0017000000MwwIQ),
(Account.Id = 0017000000MwwD1),
(Account.Id = 0017000000MwwUx),
(Account.Id = 0017000000Mwwnz)),
(ISPICKVAL( Incident_Priority__c , "1.High"),
ISPICKVAL( Request_Type__c  , "Product Issue"),
(RecordTypeId = 012700000009NR5),
(Actual_First_Response__c  <> ''))

I want any of those account IDs to be acceptable, and the rest of the criteria must be true.  I keep getting the error message tellnig me that I nee to add a )

Cheers,
Ward


Message Edited by geis6 on 11-07-2008 12:59 PM
JakesterJakester
Hi Geis,

I'd recommend getting an app like Notepad++. This will allow you to see which parenthesis ties to which. Anyway, the problem was with the open paren after your list of account ids - try this:

Code:
AND(
(OR
(Account.Id = 0017000000Mwwnx),
(Account.Id = 0017000000Mwwao),
(Account.Id = 0017000000MwwPs),
(Account.Id = 0017000000MwwIQ),
(Account.Id = 0017000000MwwD1),
(Account.Id = 0017000000MwwUx),
(Account.Id = 0017000000Mwwnz)),
ISPICKVAL( Incident_Priority__c , "1.High"),
ISPICKVAL( Request_Type__c  , "Product Issue"),
(RecordTypeId = 012700000009NR5),
(Actual_First_Response__c  <> ''))

 

geis6geis6
Thanks for the quick reply Jakester.  I'll give it a try.  I got frustrated and used the company names instead in a simple criteria fashion, but I know that a formula with the ID is the correct way to go in case of an account name change.

UPDATE:  I'm DL Notepad++ right now, but FYI.  I've tried your suggestion and I still get the error message "
Error: Syntax error. Missing ')' " when validating this formula.

Cheers,
Ward


Message Edited by geis6 on 11-13-2008 09:27 AM
JakesterJakester
I'll be interested to hear what you find - I just double-checked and as far as I can tell all the parenthesis match up. The key would be to go back and start simple, and gradually add complexity. Hope you find Notepad++ helpful, too.