I just burned 60+ minutes trying to track down the cause of an
#ERROR condition. Ultimately, I discovered it was the result of an invalid cast from a number to a string.
Here’s a quick demo base to show the error.
Obviously, I can work around the issue by inserting a
ROUND() function in my formula — but I shouldn’t have to.