Used within another function to reference the child rows of the referenced parent row
Syntax
CHILDREN([reference])
- reference—[optional]A cell in a parent row. If no cell is specified, the function references the children of the current cell.
Sample usage
COUNT(CHILDREN([Task Name]1))
Examples
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:
- The CHILDREN function in the following examples reference 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) = 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.