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.