Project Status Help

Your question is about telling whether the project is on schedule, not individual tasks. This is not a trivial question. That is why entire applications like Microsoft Project were invented.

The textbook method for determining if a project is on schedule is critical path analysis. That requires task dependencies to be identified, and your schedule doesn't show that. For example, if a task has no subsequent tasks that are dependent on it, then it can run late with no impact to the overall project completion date. An example might be performing a QA audit. But if a task has a chain of dependencies that affect the project completion date, it is on the critical path and if it is a day late, the whole project will be a day late.

Project measures can get even more complex if you use something like Earned Value to measure progress, which is a measure of how much work you actually did vs. how much work you planned to do. This is a different method than critical path analysis and is used a lot on government contracts. I'm guessing that's overkill for you.

Another method similar to Earned Value would be to use the actual percent complete of all tasks and compare to where percent complete is supposed to be based on the current date. You seem to have some of that type of data in the hidden columns but I can't figure out what you're doing there. But I think you would need a Planned % Complete.