Hide Enum options from different users

[tintin007]

Hi Community,

I don't even know if this is possible. but is there a way to hide options  in an Enum from different user groups,

eg, group A can only see Open , complete, dated, but group B could only see the option of Open.

Thought about Show if from the column in the table but not really sure if it can break it down that far.

Any thoughts on this would be helpful.

[Carlvic]

This is a form??

It depends you can try different options:

1.) Create 2 enum list and create a 2 forms and assign a show if based on users
2.) Use  valid_if https://support.google.com/appsheet/answer/10107665
3.) Check this list expression https://support.google.com/appsheet/answer/10107669?hl=en

[AleksiAlkio]

If you want this to fill the dropdown, you can do it with multple ways. The simplest one is..
IF(LOOKUP(USEREMAIL(),Users,Email,Role)="GroupA",
LIST("Open","Complete","Dated"),
LIST("Dated")
)