I can go further and say, I know it’s accurate. It’s the very formula I’m currently using. [hat tip Joshua!].
The problem is it’s very very calculation intensive, and as rows pile up, this particular formula (being used in a few different sheets and columns) is really working my whole spreadsheet. And it now seems to be causing problems as described above. Formula just randomly disappearing in the last cell, and Glide pulls in blank data, then magically reappearing seconds later. His scripting version is great too… but the problem there is what I described with glide occasionally pulling in the word “Loading…” rather than the results of the function… which… I guess wasn’t finished loading. What’s more, refreshing Glide wouldn’t replace that Loading… with the correct data. Some quirk that may have been resolved by now… but still, it’s not reliable if 1 out of ten times, Glide pulls in the data before that function has finished putting in the encoded data.