Google Sheets circular dependency error for task management sheet with task dependencies

I have made a sample sheet to show my issue: https://docs.google.com/spreadsheets/d/1YZvdHBT3G9gLM8qhas_LSPWU4prVGoOTbY6pRo1IUA0/edit?usp=sharing.

I am trying to make a task manager. Tasks have:

• Dependencies to other tasks
• Completed status - provided by the user

A task is eligible to be completed only when all of its dependency tasks have been completed.

Here is what I have and what I am trying to do:

Tasks sheet:

• Task Name
• User Input - Is Completed - this is where the user would specify if the task is completed
• Formula - Are Pre-Requisites Met - formula to determine if this task's dependencies have been met; more below
• Formula - Is Really Completed - formula; a task is only really eligible to be completed when all of its pre-requisites are met

Dependencies sheet:

• Task Name - Parent task
• Pre-Requisite - Task Name - child/dependent task
• Pre-Requisite - Formula - Is Really Completed - the value of Formula - Is Really Completed from the Tasks sheet for this row's Pre-Requisite - Task Name (the child/dependent task)

My thought is:

• On the Dependencies sheet, for each pre-requisite task, look it up in the Tasks sheet and see if it's really done (Is Really Completed)
• Then, on the Tasks sheet, for each Task Name, check the status of each of its pre-requisite task in the Dependencies sheet and make sure all are really done.

The issue is this leads to a circular reference error. But I don't think it should. Task B is dependent on task A so to determine if task A is really done we are only checking if task B is done. So there isn't a circular reference.

Not sure how to solve this...