Suoritettu

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

Taidot: Javascript, Google Sheets, Google Docs

Näytä lisää: 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

Tietoa työnantajasta:
( 6 arvostelua ) Southend on Sea, United Kingdom

Projektin tunnus: #23905336

Myönnetty käyttäjälle:

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 1 päivässä
(0 Arvostelua)
0.0

4 freelanceria on tarjonnut keskimäärin 17£ tähän työhön

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 Lisää

£20 GBP 7 päivässä
(74 arvostelua)
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 1 päivässä
(3 arvostelua)
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 Lisää

£20 GBP 1 päivässä
(1 arvostelu)
1.6