I have an app formula to get the ref rows in a virtual column. I noticed the load time increased after implementing it—is there any way to optimize the formula? List(Index(Select(Link[Invoice], And([_THISROW]=[Event Code], [Team]="Admin")), 1), Index...

I want to find the first occurrence of data and use it to apply the row filter condition.I have a table with a user ID, team, cost, and balance. I want to filter rows to only show where first appear in the team column.I have tried using lookup to get...