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).