Help

Simple Formula Problem

Topic Labels: Automations Data Formulas
464 1
cancel
Showing results for 
Search instead for 
Did you mean: 
rabidhouseplant
4 - Data Explorer
4 - Data Explorer

Hey everyone, I need some help with a simple formula I can't figure out.

 

 

 

 

"/Volumes/" & SUBSTITUTE(
  {Dept. Server Folder},
  "\",
  "/"
)

 

 

 

 I am trying to pull the content of another field on the same card. I want to add the plain text /Volumes/ to the front, then substitute instances of "\" with a "/". 

Our team has macs and PCs, and I am trying to solve a bit of a headache that our content managers feel.

1 Reply 1
rabidhouseplant
4 - Data Explorer
4 - Data Explorer

I figured it out in case anyone ever finds this. 

"/Volumes/" & SUBSTITUTE(
{Project Folder Location},
"\\",
"/"
)