Create google sheet script/formula

Cancelled Posted 6 years ago Paid on delivery
Cancelled Paid on delivery

We need a solution to process our sales data from different countries.

Our Google Spreadsheets are being populated by mailparser ([url removed, login to view]), which populates different cells based on the country the sale was made, but we need to run some formulas based on the amount sold to determine profit, costs,etc. But the new entries skip any line which has any formula. We need a solution for this issue, so we would have the other fields such as profit, costs and margin automatically populated based on the new entries sent by mail parser.

Additionally, we would like to create a pivot tables for each country and a single one showing total numbers. Feel free to ask more in case of any doubts.

Excel JavaScript

Project ID: #13966287

About the project

7 proposals Remote project Active 6 years ago

Awarded to:

sandeepsogani

I think Some macros along with scripting (maybe python) can fix your issue. The issue is arising due to multiple definitions to the cells which are misleading the data as and where to store it. Allow me to look into t More

$25 USD in 2 days
(0 Reviews)
0.0

7 freelancers are bidding on average $23 for this job

rakshitdadhich

Greetings! I am an expert in Microsoft excel/ Data entry. I would love to have the opportunity to discuss your project with you. I feel I am best fit to complete your project. I have 10 years of experience of parti More

$15 USD in 1 day
(3 Reviews)
1.5
Ashoksamriya

Turning Dreams Into Reality !! ♦ COMING is a beginning ♦ KEEPING together is progress ♦ WORKING together is success. *Our solution will always give you a great success. Your success is our SUCCESS. More

$20 USD in 1 day
(0 Reviews)
0.0
techcrunch2

Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the resu More

$26 USD in 6 days
(0 Reviews)
0.0