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 co...
Formulas and functions
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
------------------------------
  • MattMakris's avatar
    MattMakris
    Qrew Assistant Captain
    5 years ago
    Both fields are "Formula - User" type:




    ------------------------------
    Matt Makris
    ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        The field in the formula box is called [Assigned to2] and not [Assigned to (calculated)]

        What field type is [Assigned to2]?

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