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 Smartsheet Formula Template to view examples and practice working with functions in real-time.

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