Create a slug from 2 items

[Hannah_Dorling]

Hi,

I am using a formula to create a slug: SUBSTITUTE({Job Title}," “,”-")
However, is it possible to add another item in the formula, such as {location}?

Many Thanks,
Hannah

[ScottWorld]

Just use an ampersand:

SUBSTITUTE({Job Title}," ","-") & " " & {Location Field}

[kuovonne · Accepted solution]

If you want the location as part of the slug, you need to include it inside the SUBSTITUTE

SUBSTITUTE(
  {Job Title} & "-" & {Location Field},
  " ",
  "-"
)

You may also need multiple nested SUBSTITUTE functions to replace other characters that are not allowed in slugs.

[Hannah_Dorling]

That’s great, thank you!