Smart List - 2 of 4 fields are checked off

Anonymous
Not applicable

Smart List - 2 of 4 fields are checked off

I have 4 unique fields in Salesforce to represent BANT (Budget, authority, need, timeline). Each field is a true or false check box field.

I need to create a smart list that shows me all leads with exactly 2 of those 4 boxes filled in. Anyone have a suggestion for the smart list logic I would need to use to create it?

Thanks!

Steve
1 REPLY 1
Anonymous
Not applicable

Re: Smart List - 2 of 4 fields are checked off

To answer me own question, I have created a smart list that involves 24 different filters (each possible version of only 2 of the 4 boxes being checked with "or" logic). If anyone has a smarter, more efficient way to accomplish this, I would be interested in hearing it.
 

Thanks,
 

Steve