Hi there! Happy New Year to everyone! Questi...

(Aparicio Piñeyrúa) #1

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!


(Tony Fader) #2

@Aparicio_Pineyrua1 [Enumlist] = LIST(“Value 3”)

(Tony Fader) #3

@Aparicio_Pineyrua1 Another way:

AND(IN(“Value 3”, [Enumlist]), COUNT([Enumlist]) = 1)

(Aparicio Piñeyrúa) #4

@tony Many thanks! Is there a chance to create this kind of filter in “user settings”?

(Tony Fader) #5

@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.

(Aparicio Piñeyrúa) #6

@tony Thanks Tony, USERSETTINGS is ok for what I am looking for.