Help

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.

Simple Formula Problem

Topic Labels: Automations Data Formulas
878 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},
"\\",
"/"
)