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.
May 13, 2020 09:13 AM
Hi Everyone,
I am new to Airtable and enjoy it (for the most part:). I am trying to concatenate two fields (done) and then replace or substitute the spaces " " with dashes “-”. I having trouble placing the substitute syntax and getting a circular reference error. Thanks in advance for your help!
Solved! Go to Solution.
May 13, 2020 09:24 AM
May 13, 2020 09:18 AM
Your formula would look something like this:
SUBSTITUTE(({Field 1} & "-" & {Field 2})," ","-")
May 13, 2020 09:24 AM
ScottWorld, coming through in clutch, thank you and be well!