Help

Random quotations on generated formula?

Topic Labels: Formulas
814 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Raven_AtPebbled
4 - Data Explorer
4 - Data Explorer

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