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])
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"))