Using a user drop down in IF statement

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I want to use the [Project Manager] user list and convert to Initials. I tried  If(ToText([Project Manager]) = "Kenneth Ford" , "KF") but when I select myself "Kenneth Ford" it does not display anything on the form.


Photo of Kenneth

Kenneth

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Try this

If(UsertoName([Project Manager]) = "Kenneth Ford" , "KF")
Photo of Kenneth

Kenneth

  • 0 Points
That worked Perfect Thank you
The actual User value is stored as a very large negative number. :)  So not a name.  That is why the ToText did not work.