Help writing an IF formula that sums all child rows only if they are greater than 0
I'm trying to write a forumula that draws the total $ amount from a parent cell only if all of it's child rows are greater than 0, otherwise I want it to draw from a cell in another column.
Here is my formula so far but its returning INVALID OPERATION.
=IF(CHILDREN([Quote/PO Amount]@row) > 0, [Quote/PO Amount]@row, [Approved Budget]@row)
Is this possible? What am I doing wrong?
Help Article Resources
Check out the Formula Handbook template!