Adding Parent and Children Rows and need a blank response if result is 0

Judy S
Judy S ✭✭✭
in Formulas and Functions

I am using the following formula to add the child and parent rows. However, it does not pertain to all cells in that column, but I want the formula to populate with each row added. How can I make the result blank if the response is 0?

=SUM(CHILDREN([# of Lots]@row), [# of Lots]@row)

· Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭

    @Judy S

    =IF(SUM(CHILDREN([# of Lots]@row), [# of Lots]@row) =0,"",SUM(CHILDREN([# of Lots]@row), [# of Lots]@row))

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!