Substitute on attachment folder path

Appreciate your help on this.

I need the folder path name to be compounded by the number of ticket, customer, and site but without any space in the name. I am doing this, but I am not sure what I missing because despite is not showing any error on the formula, when the folder is created in drive, the spaces of the customer column and sitio name are still appearing

This is my expression:

CONCATENATE("/",Tickets,"/",[Ticket number],"_",SUBSTITUTE([Customer]," ",""),"_",SUBSTITUTE([Sitio Name]," ",""))

This is what I want to achieve:

areyes_0-1672293190027.png

This is my current output

areyes_1-1672293236511.png

 

 



0 1 113
1 REPLY 1

Questions like this should be posted in the Q&A board, where they're more likely to be seen by someone who can provide an answer and won't confuse anyone reviewing this Tips board for the type of content it's intended for. I suggested to moderators that they move the post.

In your expression, it looks like Tickets is likely missing enclosing quotes or brackets.

Confirm your column values don't include any characters unsupported in your file system.

Top Labels in this Space