These two are the same formula:
But one for the second one I had deleted the contents of the Counts table and then regenerated it. You can see it still returns the correct result within the formula editor, but not in the doc
Regenerating the data doesn’t work. Neither does manually adding a new row
Adding IfBlank("") to the end of this formula solves the problem.
Nevermind, it solved it temporarily by updating the formula in the canvas, but deleting and regenerating the underlying rows brings the problem back.
Also tried varying combinations of .First().IfBlank("") to no avail.
This is NOT a problem with WithName, as removing the WithName clause doesn’t fix the problem.
