Discussions

Expand all | Collapse all

If formula issue.

  • 1.  If formula issue.

    Posted 25 days ago
    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
    ------------------------------


  • 2.  RE: If formula issue.

    Posted 25 days 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
    ------------------------------



  • 3.  RE: If formula issue.

    Posted 25 days 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
    ------------------------------



  • 4.  RE: If formula issue.

    Posted 25 days ago
    Yay!! This worked! Thank you

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