I have a dashboard with two tabs. Now as per the access requirement, the 1st tab should be accessible to all whereas the 2nd tab only to 20 users.
I have implemented a solution, where in I edited tab2 -- Sheet Properties--Conditional and had written the below code. X and Y are user names and it is working fine. However the challenge with this solution is whenever a new user for tab2 needs to be added, everytime the code needs to be changed.
DOMAIN\Y' )=0, 0, 1)
Is there a way we can make it excel based, so that adding the usernames in the excel will allow the new user to get access in both the sheets and the application will not be required to update.