Show If - This formula is not evaluated in the context of a row, so column values are not available

[JULIARODRIGUES]

this is a reference view, i want to hide the view to some especific users
i tried or(usermail()=xxxx@xxxx.com,... ,...) then i tried this one, but the error still here

english is my second language so if there's something wrong with my grammar please let me know

[Trevwiller]

you will need to add quotations "" around the email to make it work

[Trevwiller]

Ex. - USEREMAIL() = "name@grupoccer.com.br" 

[JULIARODRIGUES]

hi, thanks for the answer but the error is still here

[Trevwiller]

Is it only a hand full of users that need to see the items? if so remove the piece IN(USEREMAIL(), lideres[E-mail],     

The USEREMAIL() is seperate from a table . It tells the system who is using the app currently. without needing to reference a table. 

https://support.google.com/appsheet/answer/10108210?sjid=16258748174228880400-NC

[Trevwiller]

This method does not require user sign in.

[MiguelPilo]

Try the next:

SWITCH( USEREMAIL(),
"(PII Removed by Staff)@grupoccr.com.br", true(),
"(PII Removed by Staff)@grupoccr.com.br", true(),
"(PII Removed by Staff)@grupoccr.com.br", true(),
false() )

To use USEREMAIL() function, be sure to enable "Require user signin?" in security menu.

And to verify the changes introduce any email to check in "Preview app as"

[jaichith]

Your requirement is so simple we can easily achieve it. 

you can try like this 

OR(
IN(Useremail(),table[column]),
IN(useremail(),list( all email id you mention. use "," one email id after. )
)

Read this :

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/DYNAMIC-USER-CONTROLS-EDIT-NO-ACCESS-ETC/td-p/5...

same logic you use in your case. 

Thank you.