I have a workbook that consists of two sheets, sheet one being a list of shots in a film and sheet 2 being tasks that are assigned to each shot. In sheet 2 I have a checkbox column to mark tasks as completed. In sheet one I have a column that shows a rollup of tasks that have NOT been completed in sheet 2. However, when I add a new task, this active task is not being counted in the rollup in sheet one, at least not until I mark it as completed and then mark it as incomplete.
Is this problem due to something I have set up incorrectly or is it a bug?