Change in status on parent record when all the child records are at a specific stage

[Aditya_Vinayak_]

Hello Peeps,

I have 3 Tables in my app:

1) WM Employee - It has Related Candidates & Related Interviews
2) Candidate - It has Related Interviews under it
3) Interview

So basically when, in the Interview table, Stage column = "Confirmation Email Sent" then the Stage column in Candidate Table should change to "Closed"

Now under one Candidate there can be multiple interviews. So until all the interview status is not as above the stage at candidate should be in In-Progress or Open.

I have created 2 actions, one is the reference action, in the interview table (Child) & Set Values action on the parent table. But not aware on how the formula works out.

Can anyone please guide on how this can be done.