# CHILDREN Function

Used within another function to reference the child rows of the referenced parent row.
Sample Usage
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.
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:

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
{"ft_lang_label":"__label__en","ft_lang_prob":0.6086578,"math_prob":0.8975366,"size":1291,"snap":"2021-31-2021-39","text_gpt3_token_len":344,"char_repetition_ratio":0.14840715,"word_repetition_ratio":0.011173184,"special_character_ratio":0.28814873,"punctuation_ratio":0.10970464,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9679095,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-09-23T09:05:10Z\",\"WARC-Record-ID\":\"<urn:uuid:dd57533c-522e-45bd-ae73-bfa3adf265a8>\",\"Content-Length\":\"51298\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:e3441f74-6d28-408a-90e9-72c291ca03be>\",\"WARC-Concurrent-To\":\"<urn:uuid:b7cff8ec-6fba-4271-bfb7-dd7975dd98c3>\",\"WARC-IP-Address\":\"199.232.66.191\",\"WARC-Target-URI\":\"https://help.smartsheet.com/function/children\",\"WARC-Payload-Digest\":\"sha1:GK5X7ZMH57IUXD7DYWF3BO7OURPAFLF7\",\"WARC-Block-Digest\":\"sha1:IX5RVL2VMF2Z5P4VBZX5M6LNFKTY2CEO\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-39/CC-MAIN-2021-39_segments_1631780057417.92_warc_CC-MAIN-20210923074537-20210923104537-00621.warc.gz\"}"}