Hello!
I have this problem, for which I have made any progress so far... It has to do with an ecommerce site and creation of facets; I want to replace the annoying parameters with descriptive URLs that will come through the use of facets.
column B (b2): http://www.ecommercesite.com (and also it has to be the result of the below)
column C (c2): http://www.ecommercesite.com
column D (d2): Level 1: Furniture
column E (e2): Level 2: Sofas
column F (f2): Level 3: Two Seater Sofas
column G (g2): Level 4: Chesterfield
column H (h2): Level 5: Muuto
I want this URL (from B2) : http://www.ecommercesite.com to show like this:
http://www.ecommercesite.com/furnint...terfield/muuto
I know that it has to be a combination of multiple IFs, CONCATENATE and LOWER but I am only 30-40% there. I am having issue with the use of hyphens within the subfolders.
That's what I have done: =LOWER(CONCATENATE(IF(C2="http://ecommercesite.com","http://www.ecommercesite.com"),H2,G2,"/",F2,"/",E2,D2))
If anyone could help that would be amazing!
Thanks!
Bookmarks