1

I will try to summarize my main goal if it's possible to achieve it.

I have a list which contains the following columns:

Invoice ID Number, Item Name, Quantity, Item Cost,Total Cost.

What i want to achieve is the following:

  • I want to add multiple items in the same invoice.

For Example:

Invoice ID 1 contains, Item Name: Shoes, Quantity: 1, Item Cost: 10$.

Now in the same Invoice ID 1 i want to add more items so the invoice now will be:

Item Name: Shoes, Quantity: 1, Item Cost: 10$.

Item Name: Shirt, Quantity:2, Item Cost:30$.

2. Now when i click save, i want the Total Cost column calculate the Items cost added to the invoice automatically per group, and showing the total cost of all the invoices similar to this one:

SumCost

I have found this tutorial but seems that the formula is outdated.

Any suggestions how to achieve the following workflow ?

Any help will be greatly appreciated.

Thank you!

2

To add multiple items in the same invoice, create a column named "Invoice ID" , don't choose "Enforce unique values".

To calculate the Items cost added to this invoice automatically, modify view, group by "Invoice ID", sum "Item Cost": enter image description here

It will calculate the Items cost added to this invoice automatically: enter image description here

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.