Discussions

 View Only
  • 1.  Create formula User field using another user field

    Posted 12-04-2017 21:13
    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!


  • 2.  RE: Create formula User field using another user field

    Posted 12-04-2017 21:16
    why not just do

    UserToEmail([Analyst])


  • 3.  RE: Create formula User field using another user field

    Posted 12-05-2017 17:30
    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).


  • 4.  RE: Create formula User field using another user field

    Posted 12-05-2017 17:34
    Actually I figured out another way for this issue. 

    But thank you for your help!


  • 5.  RE: Create formula User field using another user field

    Posted 12-05-2017 17:34
    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"))


  • 6.  RE: Create formula User field using another user field

    Posted 12-05-2017 17:31
    When I tried my original formula, it did not work as it came back as a text value in a user field