Used within another function to reference the child rows of the referenced parent row.
Sample Usage
  • [
  • reference
    A cell in a parent row. If no cell is specified, the function references the children of the current cell.

This example references the following sheet information:

  Clothing Item Transaction Total Item Number Sold Date
1 T-Shirt 1,170.00 C001 02/12/19
2 Pants 1,491.00 C002 02/15/19
3 Jacket 812.00 C003 02/20/19

Given the table above, here are some examples of using CHILDREN in a sheet:

Formula Description Result
=COUNTIF(CHILDREN([Sold Date]1), MONTH(@cell) = 2) Count the total number of sales for a given month (February in this example).  3
=VLOOKUP(MAX(CHILDREN([Transaction Total]1)), [Item Number]2:[Transaction Total]4, 2) Lookup the item number that had the highest transaction value.  C002
=SUMIF(CHILDREN([Sold Date]1), MONTH(@cell) = 2, CHILDREN([Transaction Total]1)) Returns the summed transaction total for sales that occurred during a specified month (February in this example). 3,115

Still need help?

Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.

Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.

Ask the Community