It is, though if the EnumList column is editable by the user, auto-selection will stop if the user modifies the EnumList. Set the columnโs Initial value property to an expression that produces a list of the auto-selected values. For instance:
LIST()
+ IFS(ISBLANK([Spouse Name]), {"not married"})
+ LIST(IF(([Postal Code] = "90210"), "local", "not local"))
+ IFS([Do you have a car?], {"has car"})
-
LIST() starts with a blank list.
-
+ IFS(ISBLANK([Spouse Name]), {"not married"}) adds not married to the EnumList if the Spouse Name column is blank.
-
+ LIST(IF(([Postal Code] = "90210"), "local", "not local")) adds local to the list if the Postal Code column value is 90210; otherwise, not local is added.
-
+ IFS([Do you have a car?], {"has car"}) adds has a car to the list if the user chose Y for the Do you have a car? question.
LinkedIn
Twitter
