True False from Child Records to Carry over to parent

[Ryan_Mortimer]

Hi Appsheet Community!

I have a parent row with anywhere from 1 - 10 child rows.

In the Child Rows, there is a column called [ACCEPT JOB] in which contractors can (as the name suggests) accept job (through Y/N)

I have a Y/N column in the Parent row called [ALL ACCEPTED], but I would like this to automatically switch to Y from N once all the jobs have been accepted.

I can convert this to a virtual column if needed.

Thank you all in advance!