Database

[{"_id":"62fa5aa25778ec97bc6ee231","user":"62f0eb5ebebd0f236abcaf9d","name":"Marketing Plan","columns":[{"name":"todo","_id":"62fa5aa25778ec97bc6ee233","tasks":[{"title":"Task Four","description":"This is task four","subtasks":[{"name":"wash dshes","completed":false,"_id":"62ff74bfe80b11ade2d34456"},{"name":"do homework","completed":false,"_id":"62ff74bfe80b11ade2d34457"}],"_id":"62ff74bfe80b11ade2d34455"},{"title":"Task Four","description":"This is another task four","subtasks":[{"name":"wash dshes","completed":false,"_id":"62ff74bfe80b11ade2d34456"},{"name":"do homework","completed":false,"_id":"62ff74bfe80b11ade2d34457"}],"_id":"62ff74bfe80b11ade2d34456"}]},{"name":"doing","_id":"62fa5aa25778ec97bc6ee234","tasks":[]},{"name":"done","_id":"62fa5aa25778ec97bc6ee235","tasks":[]}],"__v":0}]

Query

db.collection.update({"columns.tasks._id":"62ff74bfe80b11ade2d34455"},{"$set":{"columns.$[].tasks.$[t].title":"it works"}},{"arrayFilters":[{"t._id":"62ff74bfe80b11ade2d34455"}]})

Result