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.

CHILDREN formula in another cell.

Taylor F

Taylor F Employee

02/24/15 edited 12/09/19 in Archived 2015 Posts

I am trying to SUM the indented children rows in another cell that isn't the parent. Is this possible?

Tags:

Formulas

0 ·

Comments

SoniaR ✭

02/25/15 edited 02/25/15

Yes! The formula would look like =SUM(CHILDREN([Insert name of column]))

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Date Completed triggers Check Box
I want my user to enter the Completed date and the Check box in the Completed column gets checked. I know this is simple, and I have found answers for the other way, but I want it set this way.
I am trying us an IF statement to populate text in a cell, based off value in previous cell.
=IF(RPN@row > "400", "HIGH", IF(RPN@row < "150", "LOW", "MEDIUM")) Based off the values, the text does not always populate correctly. Example - a value of 5 will come back as "HIGH". A value of 25 shows "MEDIUM". A value of 125 shows "LOW".
IFERROR and OR
I have these two formulas in different columns: =IFERROR(INDEX({Frame ECN Updates Range 2}, MATCH([ECN / PLR / FF / CEG]@row, {Frame ECN Updates Range 1}, 0)), "") =(IFERROR(INDEX({Frame Feedback Updates Range 1}, MATCH([ECN / PLR / FF / CEG]@row, {Frame Feedback Updates Range 3}, 0)), "")) Individually, they each output…