Completed

Create formula in Google Sheet

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())

Skills: Excel

See more: google spreadsheet tutorial, google sheets formulas sum, google sheets cell reference, spreadsheet formulas list, google sheets multiply, spreadsheet sum formula, google sheets formulas if, how to add up a column in google spreadsheet, create iphone google map html file, create word template illustrator file, create animated gif low file size, create map google map, create excel order status file, create route google, create sample proofreader sheet, create joomla temlate photoshop file, create database schema csv file, create wordpress theme psd file, create route google maps visualbasicnet, joomla create article uploading word file

About the Employer:
( 0 reviews ) Leavenworth, United States

Project ID: #15741565

Awarded to:

cgullapalli

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

$60 USD in 0 days
(572 Reviews)
7.6

7 freelancers are bidding on average $138 for this job

SBITServices

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

$50 USD in 1 day
(192 Reviews)
6.9
KulfiSoftwares

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

$100 USD in 3 days
(153 Reviews)
6.9
schoudhary1553

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

$250 USD in 4 days
(191 Reviews)
7.1
asin1987

Respected Sir/Mam I will do any formula, function, formatting, calculation, modification, automation, graphs, charts on Excel. I hope to work with you. Thanks!! Relevant Skills and Experience Excel VBA Proposed Mile More

$250 USD in 3 days
(21 Reviews)
5.2
devi222

Hi Sir, I am expert in Excel formula. I can create the formulas as you mentioned in way by tomorrow. I can start right now. I have done 150+ excel tasks so far. Message me we can start now Relevant Skills and Experie More

$100 USD in 1 day
(86 Reviews)
5.6
$155 USD in 3 days
(8 Reviews)
4.1