The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I have two tables:Key Source FormulaSourcesWithin the Key Source Formula table I have a field called URL FormatAn example entry is: https://www.website.com/search/?q="Company"&t=weekIn the Sources table I have a value called Company Name Texte.g. A...
Solved by Copilot.Sometimes, adding an empty string to the fields can help convert them to text. Try modifying your formula to:SUBSTITUTE({URL Format} & "", "Company", {Company Name Text} & "")