Solved

Formula cell maodifies text

Forum|Forum|1 year ago
April 30, 2024
2 replies
22 views

A

+7

ARiios
Participating Frequently

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!

Best answer by AlliAlosa

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.

A

+19

AlliAlosa
Inspiring
Answer
Forum|Forum|1 year ago
May 1, 2024

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.

A