Subtract Invoice amount from Total based on Status, in Parent-Child relationship

Majesta

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

Majesta

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

Michelle Choate 2

Majesta

Hi @Michelle Choate 2, It looks like your answer is blank, do you mind retrying?

Majesta

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

Michelle Choate 2

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!!