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.