Issue
Formulas not calculating when dragging down. The values in the formula cell are not correctly calculated simply by dragging. Instead, the values are equal to the cell above (the first entry formula value). To get the correct value, I need to click in the formula bar and then hit enter.
Solution
Go to Formula tab, then Calculation Options and select Automatic.
