I want to check up on activities that should’ve been completed, are scheduled to be worked or are in the future.

This can be achieved in several ways. One method is using the progress spotlight feature from the toolbar. Choose View, Progress Spotlight, or click the Progress Spotlight icon to add a time period equal to the smallest increment of the displayed timescale from the previous data date. The Project Management module spotlights activities that should have started, progressed, or finished between the previous data date and the new data date in the Gantt Chart.