Column functionality breaks when copying sheet

Options

I have a template that I created to use for several projects within my org. When I create a new sheet from this template my Duration and % complete columns completely break and do not work anymore.

I have removed and recreated the columns to see if this will rectify the issue and it does not. No matter what I do I cannot get my duration and % complete columns to function correctly.

Has anyone else experienced this before and if so how did you fix the issue?

Answers