AnsweredAssumed Answered

Mutually Exclusive Smart List

Question asked by Detrie Zacharias on Feb 2, 2019
Latest reply on Feb 3, 2019 by Detrie Zacharias

I have 5 data standards based on the population of 14 fields. I need 5 Smart Lists and these all to be mutually exclusive.

Level 5 = All 14 fields are populated

Level 4 = Only 12 specific fields are populated

Level 3 = Only 8 specific fields are populated

Level 2 = Only 5 specific field are populated

Level 1 = Any of level 2 are not populated

 

I have two thoughts for the Smart Lists...

1)

Level 5 SL has all 14 fields are not empty and not a member of Level 4

Level 4 has 11 fields not empty and not a member of level 3... etc.

2)

Not use cascading Smart Lists

Level 5 = All 14 fields are populated

Level 4 = 12 specific fields are populated, the other 2 are empty

Level 3 = 8 specific fields are populated, the other 6 are empty.. etc.

 

Are either of these the best way to get there? Or, has anyone got a better idea?

 

Thanks

Outcomes