Create formula in Google Sheet

已完成 已发布的 6 年前 货到付款 结束于 6 天
已完成 货到付款 结束于 6 天

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

Excel

项目ID: #15741565

关于项目

7个方案 开放竞标 远程项目 活跃的6 年前

授予:

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 更多

$60 USD 在0天内
(572条评论)
7.6

有7名威客正在参与此工作的竞标,均价$138/小时

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, 更多

$50USD 在1天里
(192条评论)
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 更多

$100 USD 在3天内
(153条评论)
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 更多

$250 USD 在4天内
(191条评论)
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 更多

$250 USD 在3天内
(21条评论)
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 更多

$100USD 在1天里
(86条评论)
5.6