You need to sign in to do that
Don't have an account?
geis6
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
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
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:
UPDATE: I'm DL Notepad++ right now, but FYI. I've tried your suggestion and I still get the error message "
Cheers,
Ward
Message Edited by geis6 on 11-13-2008 09:27 AM