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
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.
User | Count |
---|---|
16 | |
9 | |
9 | |
7 | |
3 |