Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Random quotations on generated formula?

Topic Labels: Formulas
610 0
cancel
Showing results for 
Search instead for 
Did you mean: 

When pasting the created formula field from Airtable to another application (Chrome or TextEdit), the result adds open and closing quotations "".

Formula:
’ & Name & '’ & “\n” &
{FIELD 1} & “\n” &
"FIELD 2: " & FIELD 2 & “\n” &
"FIELD 3 " & {FIELD 3} & “\n” &

"FIELD 4 " & IF({FIELD 4}=“1”,“Yes”,“N/A”) & “\n” &
"FIELD 5 " & {FIELD 5} & “\n” &

"FIELD 6 " & IF({FIELD 6}=“1”,“Yes”,“N/A”) & “\n” &

"FIELD 7 " & IF({FIELD 7}=“1”,“Yes”,“N/A”) & “\n” &

"FIELD 8 " & IF({FIELD 8}=“1”,“Yes”,“N/A”) & “\n” &

"FIELD 9 " & IF({FIELD 9}=“1”,“Yes”,“N/A”) & “\n” &

"FIELD 10 " & {FIELD 10} & “\n” &
"FIELD 11 " & “\n” & {FIELD 12}

Result:
Sample Name
FIELD 1
FIELD 2: FIELD 2
FIELD 3 FIELD 3
FIELD 4 Yes
FIELD 5 FIELD 5
FIELD 6 Yes
FIELD 7 Yes
FIELD 8 Yes
FIELD 9 Yes
FIELD 10 FIELD 10
FIELD 11
FIELD 12”

Any idea what’s going on? The quotations doesn’t show in the cell itself, only when copied and pasted the content to other apps. Actual formula and result omitted. Thanks!

0 Replies 0