Creating a Master Project List and Dashboard

edited 12/09/19 in Formulas and Functions


I would like some help in designing  a Master Project List, and a Master Project Executive Summary Dashboard. We have a Roadmap that contains each functional area's main projects/initiatives. Is there a way I can build a formula to have all the information from each road map combined into one Master Roadmap... Which would essentially by our Master Project Summary list? Below is an example of what our Roadmaps look like. We have about 7 roadmaps of which we can not calculate how many projects we have, what status they are in, the departments. I created a Master project list column thinking that if we check it off , all the info could fall onto the Master Project List sheet.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!