I have a weird issue that I don't understand the cause. A simple logical formula is displaying TRUE in the GUI, but FALSE (as it should) when analyzing the formula.

GUI display

Formula analysis

The spreadsheet is part of work with sensitive data and thus i cannot share. Also, cannot reproduce the error, and it seems to have instability - meaning that when the spreadsheet was filled, it was displaying the correct result (FALSE) but then at some point, on its own, it changed to TRUE. I use lots of apps scripts in this sheet and so I am wondering if maybe using the equivalent of excel vba ActiveSheet.Calculate could help me here, but I don't understand why this is happening, if there's a way to prevent it from happening instead of remedying it, and i also don't see the button for a force calculate in the sheets and can't seem to find an apps script command line for that.

CodePudding user response：

Create three new cells and split up the AND arguments to the 3 cells. See what is false and what should be true to pinpoint the error.

CodePudding user response：

There is currently an open ticket regarding Google Sheets recalculation.

See if this array formula works better than your fill-down formula:

=arrayformula( true = isblank(Q2:Q) * (P2:P <> "COBRAR") )