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 Admin

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

Is there a way to put a display name on a hyperlink in the Form Description?
Is this possible? I see it was asked quite a few years back and a couple people added it as an enhancement, just wanted to see if it was ever implemented?
Removing commas if a field being joined is blank?
Have a "Reason for DQ" field that aggregates responses from hidden helper columns (finds fields with "bad" conditional formatting). What it looks like unhidden: I'm so close...but so far...how do I keep the commas separating data but remove them if the fields are blank? Forumula being used below: =JOIN([Pre-Bid…
Sheet Summary best practice - request for guidance
Hi, I have a sheet summary that is calculating the same values over and over for different categories - a total and progress counts for Fred, Wilma, Barney and Betty. What's the optimal way to do this? Should I create all values in a single sheet summary or can I create multiple summaries for the same sheet, each focused…