We are encountering a severe #CYCLE (Circular Reference) error in an Odoo 18 Spreadsheet. The issue stems from a specific calculation structure where adjacent cells mutually reference each other within IF conditions.

The Problem Structure:

The cycle occurs because one cell uses its adjacent cell in its conditional check, and that adjacent cell, in turn, uses the first cell in its calculation, creating a closed dependency loop.

Questions:

1. Is there an Iterative Calculation feature in Odoo Spreadsheet that can be enabled to handle mutual dependencies?
2. What is the recommended best practice for breaking this specific cycle in Odoo (e.g., using Helper Cells for pure calculations)?

Thank you for your assistance in finding an architectural solution for this dependency pattern.