Parent-Child auto populate a column
I am new to smartsheet and therefore asking this question. I have a form which I have used to collect faculty and what exams they are administering. One faculty can administer multiple exams (parent child relationship here). This what it looks like on the smartsheet.
My question is , is there anyway the faculty members firstname and lastname could be filled in for all the "exams" they are administering? Right now the FirtName and LastName column is blank as you can see. I looked in the INDEX and ANCESTORS formula but couldn't figure it out !
any help will me much apprecitated.