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} & "")
