Help

Formula cell maodifies text

Solved
Jump to Solution
200 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ARiios
5 - Automation Enthusiast
5 - Automation Enthusiast

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! 

1 Solution

Accepted Solutions
AlliAlosa
10 - Mercury
10 - Mercury

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.

See Solution in Thread

2 Replies 2
AlliAlosa
10 - Mercury
10 - Mercury

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.

Dan_Montoya
Community Manager
Community Manager

have you considered using concatenate()?

does it give a different result?