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]=ToUser("analyst#1 email address"), "supervisor#1 email address",[Analyst]=ToUser("analyst#2 email address"), "supervisor#2 email address")

However this formula did not work... Does anyone have any idea how to make this work?

Thank you in advance!
    • 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"))
  • NeveLeem's avatar
    NeveLeem
    Qrew Trainee
    8 years ago
    When I tried my original formula, it did not work as it came back as a text value in a user field