6 Replies Latest reply on Feb 3, 2019 10:32 AM by Detrie Zacharias

    Mutually Exclusive Smart List

    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