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
This version worked for me in a test app:
Case(not true,IsNull([User A]),[User A],IsNull([User B]),[User B],IsNull([User C]),[User C],[User D])

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