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."