Bug: EXTREMELY bizarre behavior

J. Craig Williams
J. Craig Williams ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

After the release a little while ago, the first thing I noticed was a simple sum of 7 cells was giving the incorrect value. That resolved itself when I closed and reopened the Sheet for the second time.

And then the KPI's I was working on went 'bonkers' and I noticed the attached values coming from a calculation on a cell that had a cross-sheet reference.

Further testing revealed that a formula like this:

=IFERROR(some formula based on text coming from x-sheet ref, "")

was blank. The cell used in the formula was OK.

Changing the formula to this

=IFERROR(some formula based on text coming from x-sheet ref, "err")

resulted in the formula returning the correct value (not "err")

I have a video to send to support.

My formulas are returning incorrect values. X-Sheet References are toggling (and apparently have been doing so all weekend as I worked)

I'll try again in the morning.

Craig

X-Sheet_References_Toggling.png

Tags:

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Any update on this? I haven't run across this issue yet, but I'm sure it's only a matter of time.

    thinkspi.com

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭

    I've run 4 tests this morning (8:10, 8:25, 8:40, 10:15) and so far, so good.

    I have not experienced any of the additional odd behavior (SUM() not working!!?) but the day has just begun.

    Craig

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭

    No response to my email to support sent Sun, Jul 29, 2018 at 9:44 PM

    Craig

Help Article Resources