Using Index Match with Parent Children

Melanie Bryant

Hello

I have a grid that is currently pulling the next due date from the table from the Parent/Child combo after an action is closed. I'm trying to put together an Index/Match based on that Due date and another Column in the sheet.

I want to pull the action type on the same line as the next due date but am struggling in my attempts.

Darren Mullen

@Melanie Bryant I don't have the full picture or any formulas you are trying to use in order to give any advice, but does this video help explain how to use Children() and descendants() . Not sure if that is helpful?

https://youtu.be/Dzo0UYjxMmI

Melanie Bryant

Hello,

Thanks for sharing the video, unfortunately it was not helpful. I already have a formula to show me the next due date in line (see below). I want to create a formula that pulls the Action Number based on the next due date as well. I cannot figure out the logic for that. My next date works with no issues. I assumed I would use index match but all my attempts gave errors.

=IF(COUNT(CHILDREN([Due Date]@row)) > 0, [Due Date]@row)