I have a pretty complex formula field for prioritizing leads. After much tweaking and testing, it's working well and calculates effectively for all relevant leads. However, on some leads it shows "#Error!" when shown in a Lead list view, even though it is calculating correctly on the same Lead's detail page.
I've attached two screenshots as examples. In the first you can see that the Lead has a Priority Score of 44 that has calculated just fine.
In the second you can see that the same lead, in the List View shows the Priority Score as an error.
Why would this happen?