Create formula in Google Sheet
$30-250 USD
Paid on delivery
File:(Google Sheet) Master Sheet Van Wingerden
[url removed, login to view]
Create a formula in the google sheet "Inventory" for each column named (week #). The formula will move inventory from one column to the next based on the time (Sunday evening at 12:00AM PST.) It will also look up the week# according to SKU in the "production" sheet as well as "sales" sheet to add (production) and minus (sales). Additionally, it will remove the number appearing in the production sheet "waste#" column.
The number in the current week then should give us the total inventory we have available
1.) Sheet: Inventory: COL M-BL = The formula in each column will look in previous week# column and move all existing inventory to the current week.
2.) The formula will look up the same SKU and add the number appearing in sheet "Production" in the current week.
3.) The formula will look up the same SKU and minus the number appearing in sheet "Sales" in the current week.
4.) The formula will look up the same SKU and minus the number appearing in the Sheet "Production" in the current week "waste"
Notes:
Determin Week:
=WEEKNUM(TODAY())
Project ID: #15741565
About the project
Awarded to:
Hi, I am good at Google sheet formulas. I have referred the google sheet link to work on as described. I would like to discuss further in the chat and start working on it right now. -Chandra Relevant Skills and Expe More
7 freelancers are bidding on average $138 for this job
Hello , I have read your project description and understood your requirement. I am an Expert in Excel and can complete task within time with 100% accuracy. Relevant Skills and Experience Skills : Excel, Macros,VB.net, More
I am an expert with Excel and Google Spreadsheets. Have setup advanced formulas on both the platforms, and can do this for you. Relevant Skills and Experience Please read my 260+ reviews. I am here to impress you with More
Hello Sir, I am the expert freelancer for Create formula in Google Sheet job . i have deliver more than 250 projects with 100% client satisfaction. so please give me chance to work on your job. Relevant Skills and E More