Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula using both an IF and SUM(CHILDREN()) parts


Hello people


I would like the cell in [Total]5 to show the sum of all its children, but only if the [Qty of Tasks]5 cell is empty.  If [Qty of Tasks]5 is not empty, then I would like [Total]5 to show =SUM(Tender5 + Variation5)


I have tried =IF([Qty of Tasks]5, "", =SUM(CHILDREN()), (Tender5 + Variation5) * [Qty of Tasks]5) but this comes up with an error.


I would appreciate any pointers to resolve this,


Many thanks




This discussion has been closed.