Formatting a Formula - User field for a report

Yep, indeed there is a function for that

If(Trim([Created By Id])<>"",[Created By Id], 
     UserListToNames([Assign to]))

The full list of functions is here.
https://login.quickbase.com/db/6ewwzuuj?a=q&qid=1000080

and yes working with UserList fields is confusing at first.

Fantastic! That works, too. :) And, thanks much for my intro to formulas....

I want to use this same formula for a report from our "Cases" table, where I want to display the Case Number for a Case, which might be a Case Number imported from our Salesforce records or else a new Quick Base Case Number. I want the field "Case #" (a Formula - Numeric field) to first look at the [SF Case Number] (a Numeric field) and use that value if it's there. However, if that field is empty, I want the value that's in [QB Case Number] (a Formula - Numeric field) to be used.

So, this is what the new formula looks like:

If(Trim([SF Case Number])<>"",[SF Case Number], ToText([QB Case Number]))

However, this is the error I received:

"The types of the arguments or the number of arguments supplied do not meet the requirements of the function Trim.

The function is defined to be Trim (Text t).

You may need to do one of the following to fix the problem:

• Choose the right number and type of arguments.
• Use a type conversion function to convert the arguments you are using to the correct type.
• Choose a different function."

Try this

If([SF Case Number] > 0, [SF Case Number], [QB Case Number])

Yep, that one works! Thank you...