Sum Children

Options

Nicola Alesbrook

Nicola Alesbrook ✭✭

01/05/22 edited 01/05/22 in Formulas and Functions

Hi

How do I add together all cells in children rows using a formula?

Thanks!

0 ·

Answers

Devin Lee ✭✭✭✭✭

01/05/22
Hey @Nicola Alesbrook,
For numbers
=SUM(CHILDREN())
For words
=JOIN(CHILDREN(), ", ")
0 · Share on Facebook Share 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!

Trending in Formulas and Functions

Countifs
OK - So I have a multi select cell with 4 choices (A B C D). I need to count only the cells that contain only both A & D. I tried countifs using and, contains but cant quite eliminate the counting of other combos for exampe ( A B D). Thanks in advance for any ideas.
Count if box is checked in one column and there is a specific month year in the Month Year Column
Month Year column is a text/number format. There is a space between Month and Year in the column title and a space between month and year in the column cells, ex: 07 2025 I have tried a number of formulas and am not finding one that yields the count. Here is the most recent one I tried: =COUNTIFS([Month Year], "07 2025",…
Vlookup/Indexmatch (retrieving date from one smartbook to generate in main sheet)
Good afternoon I have figured out the vLookup formula in Excel but I am having issues in Smartsheet. I want to enter a name in my main sheet (2025 OT Tracking) and then I want the Cost Center to auto-populate from my second sheet (CC&Names). I have looked at numerous formulas and I am still struggling.