That's the problem! The cell is blank, no formula entered there. Then when I fill in the shift column, the formula appears there.