Skip to main content

Simple Formula Problem

  • June 15, 2023
  • 1 reply
  • 0 views

Forum|alt.badge.img+2

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.

Forum|alt.badge.img+2

I figured it out in case anyone ever finds this. 

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


Reply