Get the 1st value of Children

Kristian Dangculos · 07/13/21

Hi, I would like to get the 1st value of children. Please see example below.

Paul Newcome · 07/13/21

Try this...

=IF(COUNT(CHILDREN(Identifier@row) = 0, Item@row, INDEX(CHILDREN(Item@row), 1))

Bassam Khalil · 07/13/21

Hope you are fine, did you need to get the first row or you need to get first submitted( date) from output column?

Kristian Dangculos · 07/13/21

Thanks, I need to get the first row of the children of the parent to parent and children

Paul Newcome · 07/13/21

Try this...

=IF(COUNT(CHILDREN(Identifier@row) = 0, Item@row, INDEX(CHILDREN(Item@row), 1))

Best Answer