If formula issue.

Question

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

MichaelTamoush · Answer

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

Sign up

Login to the community