Replacing formula with script
- Tila: Closed
- Palkinto: €80
- Vastaanotetut työt: 8
- Voittaja: grantbradshaw
Footway is a web-based platform for shoes that enables customers and manufacturers to meet. We want to make trends and collective knowledge visible to make the production of quality products even better. We believe the customers' values in quality, price and environment will be crucial for future products in fashion.
About the project
This Gsheet is our order template for purchase orders. Today the sheet is too slow because of all formulas, so the intention is to fasten the sheets.
The results are to be presented in a Google spreadsheet in a copy of this file that you share with [login to view URL]@[login to view URL] and take a print screen of the script text to upload as contest entry:
[login to view URL]
Create a script called “Sizes”
The script should replace the formulas function in section “Purchase Orders” in cells “I18:AB299” or as long there is data in column B
What we don’t want
We will reject any entries telling us you're working on the project. Only approved scripts in a shared GSheets will be accepted.
We have very limited capacity to answer questions or give individual feedback during the project, instead we will give collective feedback - this will then hopefully help you get a better understanding of what we are looking for.
We are looking for long term collaboration with skilled GSheet scripters.
“He understood my specifications perfectly and did a great job, exactly as I wanted it!”