Is there any way of selecting multiple values in a calculated field?
IF(
CONTAINS(
ANY,
[Food Type],
VALUEOF([Food Type],”Fruit”)),
VALUEOF([Food],”Apple”),
VALUEOF([Food],”Orange”),
VALUEOF([Food],”Banana”))
Archer GRC – Multiple values is calculated value list
Archer GRC – Multiple values is calculated value list
Is there any way of selecting multiple values in a calculated field?
IF(
CONTAINS(
ANY,
[Food Type],
VALUEOF([Food Type],”Fruit”)),
VALUEOF([Food],”Apple”),
VALUEOF([Food],”Orange”),
VALUEOF([Food],”Banana”))