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
    ------------------------------
    • 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/
      ------------------------------