# Need help creating formula! =SUM(CHILDREN([Time off Personal]@row<'x'))

Trying to create a formula that counts number of days off in children under parent row. Any advice???

Tags:

• ✭✭✭✭✭✭
edited 03/03/23

Hi @tjernejcic - Absolutely! Give this a try. You can put this into the Total column.

=SUM(CHILDREN([Time Off Personal]@row:[Time Off CFE]@row))

If you're only looking for one at a time, it would be =SUM(CHILDREN([Time Off Personal]@row))

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• @Amber- Thank you for the quick response. I am still getting unparseble with this new formula?!

• ✭✭✭✭✭✭

Ah, I notice that those columns have a column formula. I often have issues with formulas that reference a cell that has a column formula. Hopefully someone else can chime in!

Amber Eakin, MSLS, M.Ed.

Adult Education Specialist | Process Improvement Enthusiast

• Oh thank you for trying!!! I appreciate all the help I can get!

• ✭✭✭✭✭✭

The issue is not that the data is being populated via column formula but because we can't use multi-column ranges like that in the hierarchy based functions such as CHILDREN.

You can either put

=SUM(CHILDREN())

in each of the parent rows of those columns, or you can sum each column individually and add them all together (a couple of different ways).

=SUM(CHILDREN([Column 1]@row)) + SUM(CHILDREN([Column 2]@row)) + SUM(CHILDREN([Column 3]@row))

or

=SUM(SUM(CHILDREN([Column 1]@row)), SUM(CHILDREN([Column 2]@row)), SUM(CHILDREN([Column 3]@row)))

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!