Valid IF statement but only for user account and not for admin

Hi,

How can I get following Valid-if statement to work only for a user account and not an admin account.
the admin should get the full list of drivers.

SELECT(Driver[Name], [Email]=USEREMAIL())

Thanks you

0 1 77
  • UX
1 REPLY 1

I was able to get this to work using the below valid if statement. but it breaks the links between the driver and I get a yellow triangle next to the selected name.

IF(USERROLE() = โ€œUserโ€, SELECT(Driver[Name], [Email]=USEREMAIL()), Driver[Name])

How can i set this up and still keep the linked driver?

thank you.

Top Labels in this Space