Hi I have a question relating to expressions. I have a form whereby the user email entered automatically fills out the next column [Operator]. In the AppSheet App, Auto compute, Formula for column Operator (Name) I have the following formula entered:
IF([User Log In] = โJohnDoe@gmail.comโ, โJohn Doeโ, John Doeโโ)
What I want to do is add more user emails and different operator names only I donโt know how to write this expression. Just for clarification I would like it to be like this;
IF([User Log In] = โJohnDoe@gmail.comโ, โJohn Doeโ, John Doeโโ) + IF([User Log In] = โJaneDoe@gmail.comโ, โJane Doeโ, Jane Doeโโ) + IF([User Log In] = โJohnSmith@gmail.comโ, โJohn Smithโ, John Smithโโ)
Solved! Go to Solution.
Hi @Steve that worked perfect. Thanks for the guiding me in the right direction. This worked:
IFS(
(USEREMAIL() = ***@gmail.com), โJamesโ,
(USEREMAIL() = ***@gmail.com), โJackโ,
TRUE, โโ,
)
Cheers for the help.
Also:
User | Count |
---|---|
45 | |
34 | |
27 | |
23 | |
15 |