- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 30, 2024 03:17 PM
Hi!
I'm having trouble with a formula where it brings back text and adds " " when it is done.
Here is the layout:
Column 1: Formula cell with the following formula {Client} & ' - ' & {Total Volume}
Column 2: Linked to another table, displays {Client} names (Example: John)
Column 3: {Total Volume} quantity (Example: 10)
What I want to get from this formula is = John - 10
What I'm getting from this formula is = “John“ - 10
Is this because I am linking to another table? It does not happen with every value from the {Client} column!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 30, 2024 05:46 PM
The quotes signify that you either have a commas or a line break in your primary field on the table housing your clients. If you open up the record for “John”, I would guess there’s a carriage return after his name.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 30, 2024 05:46 PM
The quotes signify that you either have a commas or a line break in your primary field on the table housing your clients. If you open up the record for “John”, I would guess there’s a carriage return after his name.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 30, 2024 06:59 PM
have you considered using concatenate()?
does it give a different result?
