UserToName show blank instead of "Invalid"

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

I have Assignments and can either be completed by Vendors or Team Members.  It's either one or the other, it can't be done by both.  I'm trying to create one column in a report that will either show the Vendor or Team Member assigned to the task.  Here is the formula I'm using to combine the two fields into one column.

List(" ",ToText([Vendor Full Name]),UserToName([Team Member],"LF"))

The problem with this is that if it is a Vendor and not a Team Member, the name is showing up as "Smith, John Invalid"  I don't know how to show get rid of the "Invalid" part.





Photo of Carlos

Carlos

  • 100 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Not tested but try this

List(" ",
ToText([Vendor Full Name]),
IF(not IsNull([Team Member]), UserToName([Team Member],"LF")))
Photo of Carlos

Carlos

  • 100 Points 100 badge 2x thumb
That was it.  Thank you.