On the Contracts sheet in the attached spreadsheet when I try to sort the sheet the 'Billed to Date' column sorts differently and gets out of order, associating values with the wrong records. I have tried turning Filter on and off and cannot figure out what the issue could be. Any help is greatly appreciated!


Edit: And of course I just fixed it by removing the Contracts! reference in the formula

Attached Files

Facilities Invoice Tracking 2017.xlsx (36.0 KB, 13 views)

So the problem is solved?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post