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
XavierFan's avatar
XavierFan
Qrew Cadet
6 years ago
Try this formula.  You may want to put  a default user at the end, in case [User D] is also blank.

If(
IsNull([User A]) = false, [User A],
IsNull([User B]) = false, [User B],
IsNull([User C]) = false, [User C],
IsNull([User D]) = false, [User D]
)

------------------------------
Xavier Fan
Quick Base Solution Provider
http://xavierfanconsulting.com/
------------------------------
Lightning0114's avatar
Lightning0114
Qrew Cadet
6 years ago
Thank you! Will try this one. Appreciate your help.

------------------------------
Ma. Isabel Gumanid
------------------------------