I have two tables:
- Key Source Formula
- Sources
Within the Key Source Formula table I have a field called URL Format
An example entry is: https://www.website.com/search/?q="Company"&t=week
In the Sources table I have a value called Company Name Text
e.g. Apple, which I want to substitute into the URL Format. This should return a result like:
https://www.website.com/search/?q=Apple&t=week
The SUBSTITUTE formula I have is:
SUBSTITUTE({URL Format}, "Company", {Company Name Text})
It returns #ERROR.
I have even used the Airtable AI to write this formula and it doesn't work.
Any help much appreciated
