A few days ago, I created a Google Spreadsheet and from what I remember, it was working fine. When I came back to it today, I saw that a few cells said Loading... despite all cells in the column have the same formula (except for the cell reference). What I've tried to fix this:I figured it must be an issue with my custom function, so I put a return statement at the beginning of the function to verify that, and that didn't fix the issue.I changed the equation and changed it back because I saw similar questions get solved by doing that.I flipped the equations (cell references) in a working cell and a nonworking cell, and the value was displayed in both, which seems to show that the equation isn't broken, and the cell isn't broken, but somehow it still doesn't work.I tried it on a different browser to see if caching is the issue.This is what I have: Cell E2: =IF(J2 = Yes, MYFUNC(C2, D2, Sheet2!C$2:C), ) results in 42Cell E3: =IF(J2 = Yes, MYFUNC(C3, D3, Sheet2!C$2:C), ) results in Loading...function MYFUNC(foo, bar, baz) {  return 42;  // more code that won't get run now}Given what I've tested, it makes me think that it is a bug, especially since I don't know how I could replicate it. Has anyone else seen something like this or know a solution to this problem?
Google Spreadsheets Loading Bug
google spreadsheets;google apps script