+12I have a formula field that includes a linked record field {Supplier}. The result is the text in the linked record field has quotation marks. Is there a way to remove the quotation marks from my results?
DATETIME_FORMAT({Purchase Date},‘YYYY-MM-DD’) & “-” & {Supplier}
2018-03-31-“Supplier ABC - Your Town, WA - Unknown Address”
Many thanks :pray:
Best answer by ScottWorld
Create a lookup field based on your linked record field (Supplier), and lookup the primary field (which will be the Supplier).
Then, use that lookup field in your formula instead of the linked record field.
+35Create a lookup field based on your linked record field (Supplier), and lookup the primary field (which will be the Supplier).
Then, use that lookup field in your formula instead of the linked record field.
+12Create a lookup field based on your linked record field (Supplier), and lookup the primary field (which will be the Supplier).
Then, use that lookup field in your formula instead of the linked record field.
Thank you! :pray: :grinning:
+35You’re welcome! Glad I could help! :slightly_smiling_face:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.