Subtract Invoice amount from Total based on Status, in Parent-Child relationship
Hi all,
I am new to create sheets, but I am trying to create a solution to track forecasted invoices that need to be sent out. I want to put each invoice total separately and when the status is marked as "Complete" I would like to have it subtracted from the Contract Amount to show the Contract Balance. I set it up so the invoice amounts are subtracted from the Contract Amount, but it does it when I input any amount, which is not helpful. I currently have
=[Contract Amount]@row - SUM(CHILDREN([Invoice Amount]@row))
in the "Contract Balance Column" but can't figure out how to make it a SUMIF the Status is "Complete" with the parent child relationship.
Thank you!
Majesta
Best Answer
-
In case anyone is wondering, I found an answer in another post. My solution is
=[Contract Amount]@row - SUMIFS(CHILDREN([Invoice Amount]@row), CHILDREN(Status@row), "Complete")
Answers
-
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
-
Hi @Michelle Choate 2, It looks like your answer is blank, do you mind retrying?
-
In case anyone is wondering, I found an answer in another post. My solution is
=[Contract Amount]@row - SUMIFS(CHILDREN([Invoice Amount]@row), CHILDREN(Status@row), "Complete")
-
sorry!! I had left a formula but my power went out and I haven't been able to log back in. Sorry I was not the best help!! Soo glad you found your answer!!
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!