Multiple Projects- Dashboard to track on time delivery


I manage multiple projects, about 20, each with their own project plan sheet. I'd like a report or dashboard that shows me across all the project sheets how I am tracking based on a due date. As shown in the attached project example, I always have a last task which is Project Complete. I'd like to make sure that the Project complete date is on or before a final due date. In the case below I tried to use the Due this Week column to add a due date. But I want to track this across multiple sheets and be able to see it all on one report or dashboard.

One thought would be to see the Project name with Due Date, Expected Project Complete date, and if the project completion is after, the cell or text turns red.

Thanks for the help!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!