LinkedIn
Twitter
Hi,
I’ll try to make this as simple as I can: I have an app that we use to record orders. It has 3 sheets: Company, Employees, Order. The Employees and Order sheets reference the Company Sheet. When an order arrives, we select the Company then “Add Order” to record their order.
What I’d like to do is when an order arrives for the app to find the Employee linked to the Company whose title is “Buyer” and add the value of the order to the Buyer’s Cumulative Sales.
Right now, I’m updating this column manually. My problem is, I can’t seem to be able to connect the Order sheet to the Employee Sheet as there are many Employees for each Company.
Here’s a diagram which I hope might make things a little simpler to understand. The black is what I’ve currently got, the red is what I’d LIKE to happen automatically if possible.
