Help

Concatenate Two Fields and Substitute

Topic Labels: Formulas
Solved
Jump to Solution
1332 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Ed_Brooks
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
Ed_Brooks
5 - Automation Enthusiast
5 - Automation Enthusiast

ScottWorld, coming through in clutch, thank you and be well!

See Solution in Thread

2 Replies 2

Your formula would look something like this:

SUBSTITUTE(({Field 1} & "-" & {Field 2})," ","-")

Ed_Brooks
5 - Automation Enthusiast
5 - Automation Enthusiast

ScottWorld, coming through in clutch, thank you and be well!