Forum Discussion

MattMakris's avatar
MattMakris
Qrew Assistant Captain
5 years ago

Problems with if statement in User Formula field

I am trying to use an if statement in a user formula field and it doesn't seem to be working. It is designed to determine whether a checkbox is checked, then outputs a user field value based on the condition.

If ([my checkbox]=true,
  [user field A],
  [user field B (via relationship)]
)

I am getting the following error with the field in the else output highlighted:
"expecting text but found user"

Any ideas?


------------------------------
Matt Makris
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Change the field type to formula user and it now seems to be a formula text field type.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • MattMakris's avatar
      MattMakris
      Qrew Assistant Captain
      5 years ago
      That's the confusing part - it already is a user field:



      ------------------------------
      Matt Makris
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        It must be mismatched field types within the IF.  What field type is [Assigned to2].  It must be a text field type.


        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------