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




        ------------------------------
        Matt Makris
        ------------------------------