Apply Filter/Formula in Slice

[arindam_samant1]

Hello experts,
I have the below data in my spreadsheet:

If you see the 10 th row, my name is available and my team name is crisis management. Now I would like to display only my team information if I will execute the application. If some one crisis management log in, then he or she will have only information form crisis management team. I think for this, I need to create one slice but which formula or select or list will be best possible solution to make this?

Could you please help me to make one formula or select or list or filter?

Thanks,
Arindam.

[Aleksi · Accepted solution]

Something like [TEAM]=LOOKUP(USEREMAIL(),YourTableName,Email,Team). You would need to have email column in this table as well.

[arindam_samant1]

Aleksi:

[TEAM]=LOOKUP(USEREMAIL(),YourTableName,Email,Team)

Hello Aleksi,

Thanks for your reply. It is working for me.

Thanks,
Arindam.

[Aleksi]

You’re welcome