Completed

Very Simple Custom Sort in Google Sheets Script

This is for Google Sheets. I need a custom Google Apps script that will take my list of product SKUs and sort them in order of SKU AND size.

The cell value is like the list below. The first sorting is the first part of the value E.g. ‘SD0266’ or ‘SD0263’. These will be placed in alphabetical order and that is easy. The function will need a predetermined order for the size values. The order will be as follows “XXS,XS,S,M,L,XL,XXL,XXXL”

So the sorting will be SKU then SIZE.

This list:

SD0266 XXL Navy

SD0266 XS Navy

SD0266 S Navy

SD0266 M Navy

SD0266 L Navy

SD0263 XXL Navy

SD0263 XS Navy

SD0263 XL Navy

SD0263 S Navy

SD0263 M Navy

SD0262 L Navy

SD0262 M Navy

Will become:

SD0262 M Navy

SD0262 L Navy

SD0263 XS Navy

SD0263 S Navy

SD0263 M Navy

SD0263 XL Navy

SD0263 XXL Navy

SD0266 XS Navy

SD0266 S Navy

SD0266 M Navy

SD0266 L Navy

SD0266 XXL Navy

Skills: Javascript, Google Sheets, Google Docs

See more: script will install astbill, custom markers google maps numbers, custom marker google maps, asterisk script will data mysql, seo oscommerce page sort google, perl script will increase plays myspace, wordpress custom search google, simple script will auto pull content adult, custom marker google map script, simple custom marker google maps, script code custom markers google maps, script will use addresses send searches google bing, php script will connect google shopping api, script update cell google sheets, i am looking for someone to write a google apps script in google sheets, Very basic site with a lead capture to google sheets, \ google sheets script\ , \ google sheets\ script

About the Employer:
( 6 reviews ) Southend on Sea, United Kingdom

Project ID: #23905336

Awarded to:

legioner80ru

Hello, Thank you for interest in my profile. I am ready to implement your task. I have a strong knowledge of Google Sheet automation best regards, Dima

£11 GBP in 1 day
(0 Reviews)
0.0

4 freelancers are bidding on average £17 for this job

mak94pk

Hello Sir/Mam, MAKSOF is a team of highly qualified professionals who is dedicated in providing creative solutions and innovative ideas for your business with our skills in technologies and strategies. We have read More

£20 GBP in 7 days
(74 Reviews)
7.1
NaliRaz

Hi, I can help you with this project and create this script. I have a good experience with google apps script / google sheets. Please, feel free to contact me over chat. Best Regards, Naly

£18 GBP in 1 day
(3 Reviews)
3.7
iGeeks

I am ready for a custom Google Apps script that will take my list of product SKUs and sort them in order of SKU AND size. The cell value is like the list below. The first sorting is the first part of the value E.g. ‘S More

£20 GBP in 1 day
(1 Review)
1.6