I have two objects.
Work (Master Object) Field: Work Done Tasks (child object) Field: Work Done
I want to create a formula field on the master record Work so that when the last 3 records of the Child object Tasks field Done = True, it would set the field on the parent object to true.
How can I do this using a formula? or would I need to use scheduled Apex?