For some users I need an Enum to limit to one selection. For others I need an EnumList to allow multi-selects. Based on the same data column.
Is there a way to do this?
Not sure if this helps, but hereโs one I did this week where you can have โCustomerโ on its own, or any number & combination of the others
OR(
AND(
IN("Customer",[Type]),
COUNT([Type])=1
),
NOT(IN("Customer",[Type]))
)
On rereading the requirement, I think @1minManager โ suggestion is in the correct direction. I had slightly misunderstood the requirement so I deleted my suggestion. I think the requirement is to restrict to โany oneโ selection in the enumlist. I probably misread the restriction to โone specific valueโ.
Pattern for Valid If:
IF(
user-allowed-many-choices?,
LIST(...multiple-items...),
LIST(one-item)
)
Example:
IF(
IN("Privileged", Current_User[Type]),
LIST("Good", "Great!", "Amazing!"),
LIST("Good")
)
User | Count |
---|---|
39 | |
29 | |
23 | |
23 | |
13 |