excel filter not working with formulas

The current mode will have a checkmark next to it. Autofill won t work as expected. How To Filter Records Using…