Forum Discussion

BrandyNunes1's avatar
BrandyNunes1
Qrew Member
5 years ago

If formula issue.

I am trying to write an if formula that says, if (specified field) is = "user", then check the box, otherwise, don't check the box.

I tried the formula: 
If([Opportunity - Construction Manager]=ToUser("Timothy Mumpower"),true, false)
which did not give the desired result. 

and I've tried the formula: 
If([Opportunity - Construction Manager]Begins("Timothy", "Mumpower")true, false))
which highlighted the first part of the formula Yellow, and the message:The expression [Opportunity - Construction Manager] on the left hand side of the operator "<>" is of type user while the expression "Timothy Mumpower" on the right hand side is of type text. The operator "<>" cannot be used with these types of expressions.

admittedly I understand very little of this but I am trying to learn. Can someone help?

------------------------------
Brandy Nunes
------------------------------
Formulas and functions
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    5 years ago
    Someone else might have a better answer, but my check when I cant figure this out is to create a formula text field called "ToUser("User Name") and see what it pops out. I think it's the email of the user. Either way, it allows you to look at that field, and your original field that you are comparing to, and figure out what the difference is.

    I suspect you need to use: UserToName([User Name]) in your If statement

    ------------------------------
    Mike Tamoush
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Quick Base users are global and your Tim Mumpower may not be the only one on the planet.  You can imagine the problem with more common names. So you need to use their email so it's unique.


    If([Opportunity - Construction Manager]=ToUser("tmumpower@MyCompany.com"),true, false)
    which did not give the desired result. 

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • BrandyNunes1's avatar
      BrandyNunes1
      Qrew Member
      5 years ago
      Yay!! This worked! Thank you

      ------------------------------
      Brandy Nunes
      ------------------------------