Searching through the children rows

Hunter Gade
Hunter Gade ✭✭
edited 12/09/19 in Smartsheet Basics

    I'm trying to write a function that searches through the children rows of parent rows and if one of the rows meet a condition ( "In-Use" ) in the use column, it'll display a name in the User column on the parent row to show who is the current user of a particular asset. I've been trying to use CHILDREN, DESCENDANTS, etc... but I can't come up with a function to make this happen.

Any suggestions would be very helpful!

Thank you,

Hunter G.

Asset Allocation Issue.png