
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 09, 2020 12:05 PM
This has been asked a few times but I can’t seem to find the solution that works.
I have a formula "CONCATENATE({For Formula},{Market},{Product Management},{Product Category},{Gender})"
but its output adds unwanted quote marks like so:
What I really want is to have it be separated by “/” but I’ve exhausted the time I have trying to fix that. How can I get this to output something with consistent quote marks - or comma separation - or preferably the /
Thanks!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 11, 2020 11:34 AM
Thanks for the update. When referencing a link field, Airtable will sometimes wrap the names of the linked records in quotes, but that usually only happens when the primary field in the linked record contains commas. My only thought now is that there may be some invisible characters in those primary field names that Airtable is hiding when displaying the field, but they might show up if you edit the field, and it might be doing the quote-wrapping treatment as a result. As a test, double-click to edit that “Consumer” name to check for anything before or after the word itself. In fact, just retype “Consumer” manually to replace it, then see if you still get the quotes around it in your formula output.

- « Previous
-
- 1
- 2
- Next »