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

------------------------------

Original Message:

Sent: 05-05-2020 14:10

From: Brandy Nunes

Subject: 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

------------------------------