#ERROR with SUBSTITUTE Formula

[hunter86]

I have two tables:

1. Key Source Formula
2. 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

[hunter86 · Accepted solution]

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

[anavi]

Thanks, I had the same problem and this solved it! Don't understand the logic, but it worked!