How can I ensure that non-clients have no client management?

My formula so far (without spaces here):

AND( OR( ISPICKVAL( Type, "Prospect"), ISPICKVAL( Type, "Is this a Prospect or User?"), ) , ISPICKVAL( Client_Management__c,"") ) 

The other Types of accounts are either clients or ex-clients.

But for the Types specified, I'd like for the Client Management field to be required to be blank (it is a picklist field by the way).


The rule has to evaluate to TRUE in order to cause a validation error, so you are probably looking for:

AND( 1 = CASE(Type, "Prospect", 1, "Is this a Prospect or User?", 1, 0),
     NOT(ISPICKVAL(Client_Management__c, "")))

CASE is simply used to reduce the impact of the compiled function size, although I do find that this form is a bit easier to read.

Category: formula Time: 2016-07-28 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 0.280 (s). 12 q(s)