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