I have an expression where based on the logged in user’s team name, a slice will return a subset of data from my main table. I went with an assumption that 1 user has 1 team, but now have a use case where a user wants to see multiple team allocations. Can anyone suggest an edit to the formula below, please?
I’m looking to return the rows where the user could have 2 x “Team Name” listed in the Users table, i.e., Team A , Team B
AND([Portfolio Status]= “Active” ,
[team name] = LOOKUP( USEREMAIL() , “Users” , “Useremail” , “Team Name” ))