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

Z.Win

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!

Paul Newcome

Try something like this...

=INDEX(CHILDREN(), 1)

Paul Newcome

Try something like this...

=INDEX(CHILDREN(), 1)

Z.Win

https://community.smartsheet.com/discussion/comment/312299#Comment_312299

thank you Paul, that's exactly what i needed. Now to just do an if for parent vs child rows.

Paul Newcome

Happy to help. 👍️