Sorry, in the starting view I want the to dis...

Sorry, in the starting view I want the to display different view for different users. Could you help me with the expression.? What or how should I write?

0 4 393
4 REPLIES 4

@Account_Team

=SWITCH( USEREMAIL(), "aa@bb.com",“ViewName1”, "cc@dd.com",“ViewName2”, “DefaultViewName” )

Thank so much

If you have a lot of different users, it is best to classify them by role (Table with 2 columns, Email and Role) and then use a formula to change the view. Something like IFS(Lookup(USEREMAIL(),RoleTable,Email, Role)=“Role1”,View1,…)

If you use the view name directly in this “user table”, you could read it like LOOKUP(USEREMAIL(),Table,Email,ViewName).

Top Labels in this Space