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:
This is my current output
User | Count |
---|---|
15 | |
10 | |
9 | |
7 | |
3 |