Use this function to reference column values of a parent row's child rows.
Syntax
CHILDREN([reference])
- reference—[optional]A cell in a parent row (e.g., [Task Name]1 is the first row's Task Name cell). If no cell is specified, the function references the children of the current cell.
Sample usage
COUNT(CHILDREN([Task Name]1))
Examples
The examples reference the following sheet:
| Clothing Item | Transaction Total | Item Number | Sold Date | |
|---|---|---|---|---|
| 1 | Autumn Wardrobe | |||
| 2 | T-Shirt | 1,170.00 | C001 | 02/12/19 |
| 3 | Pants | 1,491.00 | C002 | 02/15/19 |
| 4 | Jacket | 812.00 | C003 | 02/20/19 |
Given the sheet above, here are some examples of using CHILDREN in a sheet:
- The CHILDREN function in the following examples reference row 1, which is a parent row. More on Rows and Hierarchy.
- Some of these examples use the @cell parameter. More on @cell.
| Formula | Description | Result |
|---|---|---|
| =COUNTIF(CHILDREN([Sold Date]1), MONTH(@cell) = 02) | 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) = 02, CHILDREN([Transaction Total]1)) | Returns the summed transaction total for sales that occurred during a specified month (February in this example). | 3,473 |
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.