Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
22 hours ago
Solved

User to Name

I'm trying to use"UserToName([Current PR Assigned], "LF"))", however if there is no user in the field, it comes back with invalid.  How do I get it to just be blank if there is no user?

I have tried this and it says expecting user but found text for the UserToName part.

If([Current PR Assigned Is null]="yes",[Blank User],UserToName([Current PR Assigned], "LF"))

Any ideas?

formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    22 hours ago

    not tested but try this

    IF(not IsNull([Current PR Assigned]),

    UserToName([Current PR Assigned], "LF"))