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


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.


Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    Try something like this...



Sign In or Register to comment.