Anyone who has used monday.com for a while knows the formula column is a bit of a mess. Mirror columns of numbers that show 0 get treated differently if its 0 because all connected items are empty or one or more say 0. This is just one of dozens of oddities and unexpected behaviors.
I realize the Formula column as it is cannot be fixed without breaking existing formulas in unexpected ways.
Deprecate the existing formula column, and create a new formula 2.0 column that isn’t a mess, that can be used in automations, or updates, emails, the API etc.
We’re mostly all adults here and can accept that the existing Formula column cannot be fixed without breaking things. Give us a clean start that works.