[{"_id":"61e3050a465c380aec9f56a1","name":"John Doe","status":"pending","payment":[{"status":"completed"},{"status":"completed"}]},{"_id":"61e3050a465c380aec9f56a2","name":"John Doe","status":"pending","payment":[{"status":"completed"},{"status":"pending"}]}]

db.collection.update({},[{"$addFields":{"status":{"$cond":{"if":{"$allElementsTrue":{"$map":{"input":"$payment.status","as":"s","in":{$eq:["$$s","completed"]}}}},"then":"completed","else":"$status"}}}}])