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
Lightning0114's avatar
Lightning0114
Qrew Cadet
6 years ago
Thank you! Will try this one. Appreciate your help.

------------------------------
Ma. Isabel Gumanid
------------------------------
XavierFan's avatar
XavierFan
Qrew Cadet
6 years ago
(for some reason - I encountered an error when trying to reply to your message)

Ok - if you want to check [User A] against some email, try this formula:

If(
IsNull([User A]) = false and UserToEmail([User A]) <> "supervisor@gmail.com", [User A],
IsNull([User B]) = false, [User B],
IsNull([User C]) = false, [User C],
IsNull([User D]) = false, [User D]
)

The UserNameToEmail changes the User into the email it corresponds to, and you compare that with the email that you have.

Then the rest of the formula is the same.  Hope this helps!

------------------------------
Xavier Fan
Quick Base Solution Provider
http://xavierfanconsulting.com/
------------------------------