Forum Discussion

NeveLeem's avatar
NeveLeem
Qrew Trainee
8 years ago

Create formula User field using another user field

Hello.  I have an analyst field-user and leadership field-formula user. All users are QB users. For Leadership field, I created a formula to say something along the lines of If ([Analyst]=ToUs...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
why not just do

UserToEmail([Analyst])
  • NeveLeem's avatar
    NeveLeem
    Qrew Trainee
    8 years ago
    You mean something like
    If (UserListToEmails([Analyst])="analyst #1 email address", "supervisor#1 email",
    UserListToEmails([Analyst])="analyst #2 email address", "supervisor #2 email")
    ???

    When I tried this, it gave me an error.
    "The types of the arguments or the number of arguments supplied do not meet the requirements of the function UserListToEmails.

    The function is defined to be UserListToEmails (UserList ul).
  • NeveLeem's avatar
    NeveLeem
    Qrew Trainee
    8 years ago
    Actually I figured out another way for this issue. 

    But thank you for your help!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    I don't think I read your question carefully enough.

    I think you want to hard code the leadership Userid by formula.

    If (
    [Analyst]=ToUser("analyst#1 email address"), ToUser("supervisor#1 email address"),[Analyst]=ToUser("analyst#2 email address"), ToUser("supervisor#2 email address"))