Hi there! Happy New Year to everyone!
Question. If I had a column that fetch more than one value from an Enumlist. How can I filter the data inside that column?
Eg: I had 3 Items in [Item] and in the column with the data of the Enumlist I had in Item 1 in [Enumlist] values 1 and 2, In Item 2 in [Enumlist] values 2 and 3 and in Item 3 in [Enumlist] values 1 and 3.
How can I filter the items that only has in [Enumlist] value 3?
Many thanks!
Apa
@Aparicio_Pineyrua1 [Enumlist] = LIST(โValue 3โ)
@Aparicio_Pineyrua1 Another way:
AND(IN(โValue 3โ, [Enumlist]), COUNT([Enumlist]) = 1)
@tony Many thanks! Is there a chance to create this kind of filter in โuser settingsโ?
@Aparicio_Pineyrua1 Yes, you could use user settings instead of a single-row table to do this. However, user settings changes require a full sync so it wonโt be as seamless.
@tony Thanks Tony, USERSETTINGS is ok for what I am looking for.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |