Forum Discussion

Lettie014's avatar
Lettie014
Copper Contributor
Jul 26, 2022

Custom Sort

Hi, 

I am trying to sort our product list and i have come to a stand still. 

our products look like this. 

there is a name of the PARENT SKU (full product) and under child sku the components. 

i want to be able to filter products by using PARENT SKU Alphabetically for first part of the SKU and custom sort for size aka SIN, SMDBL, DBL,KNG ( i have set up custom sort)

If i sort by RANGE, COLOUR, PARENT SKU (BY GREY FIRST) than SIZE- It goes wrong 

if i sort by PARENT SKU, RANGE (GREY FIRST) , CHILD SKU, COLOUR, THAN SIZE - It doesnt register the size because its picking up on DBL in PARENT SKU BEING ALPHABETICALLY 

Any help would be appreciated 

Thanks 

Lettie 

    • Lettie014's avatar
      Lettie014
      Copper Contributor
      I have done that but used white font to make it look cleaner.
      • HansVogelaar's avatar
        HansVogelaar
        MVP

        Lettie014 Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

Resources