How do i make a formula that references the first child row?

11/30/21
Accepted

i have a sheet where i'm trying to track recurring payments and give me and easy way to see the upcoming payments. currently the status column has a formula that turns yellow ahead of the payment due date to alert me that i need to start this process. The "Done" rows are there in case i need to look at historical records and attachments from pervious years.

What i'm hoping for is a way to do something like =Status(@row+1) for the parent. i know that's not the correct syntax, but i was thinking that would be the easiest way for me to see what's upcoming when all the children are collapsed.

Thanks!

Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    Try something like this...

    =INDEX(CHILDREN(), 1)

    thinkspi.com

Answers

Sign In or Register to comment.