What is the proposed idea/solution?
User would like to limit the items show to unique values only.
I.e. when a lookup field references a multi-select/single-select field from a linked record. Suppose there is 20 linked records, each of which has a multiselect cell filled in with 3 available options, Name 1, Name 2, Name 3. Supposed in the list of 20 linked records, there are 7 with the name 1 option selected, 9 with the name 2, and 4 with name 3. In the lookup field, I will see all iterations listed out, ("name 1", "name 1", "name 1", etc.... "name 3." totaling a string of 20 names. Ideally the user would like to just see "name 1" once, "name 2" once, and "name 3" once, since all of the other iterations are just duplicates. If the items are not unique, they are not duplicated in the string.
The best way to do this would be to add an additional toggle switch for "Limit the items shown to unique values."
How does is solve the user problems?
Consolidates data, making it both more printable, easier to read, and removes the need to have an additional formula field to accomplish the same effect.
How was this validated?
Not sure if this question is applicable.
Who is the target audience?
Any user primarily working in project management, task delegation, and anyone who like to run automated reports.
