Help writing an IF formula that sums all child rows only if they are greater than 0

Options

Hi,

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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!