Dynamic Sum from Multiple Sheets in a Workspace

edited 12/09/19 in Formulas and Functions


I have a workspace full of our active projects. Each tasks has a status (not started, in progress, complete) and I would like be able to see the total numbers of these tasks statuses across all the projects. I already have columns that count the number of each task status in the individual projects, but I would like to be able to add or remove a project to the workspace, and have the total numbers update accordingly. Ideally I would not need to manually link/unlink and cells each time a project is added/removed from the workspace. Is this possible? I can make a report of, say, the "In Progess Count" column but I cannot use formulas in a report. Thoughts?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!