Random quotations on generated formula?

#1

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 Likes