Forum Discussion

Lightning0114's avatar
Lightning0114
Qrew Cadet
6 years ago

Formula-User field that shows value of another Nonempty user field

#field​ #Formulaandfunctions  Hi. I have a formula user field FINAL USER that should show the User A if "User A" field is nonempty, else it should show User B, but if User B field is empty, it should...
field
Formula and functions
EricMohlman's avatar
EricMohlman
Quickbase Staff
6 years ago
Isabel,

It looks like your response was sent privately, so others can't see the update. Here it is in case anyone wants the context:
 I forgot to mention which will only apply to User A. It should be "If User A is not empty and not equal to supervisor@gmail.com, then show User A". Any thoughts?​
To accomplish that, I would use this type of formula:
If(not IsNull([User A]) and UserToEmail([User A])<>"supervisor@gmail.com",[User A],Case(not true,IsNull([User B]),[User B],IsNull([User C]),[User C],[User D])

------------------------------
Eric Mohlman
------------------------------