Can I use SUMIFS to total a value accross somesheets within a workspace?

Example: I have a workspace that have 300 folders for 300 different project names. Each project name have subfolders in which one is called sheets. The sheets have 4 sheets in which one is called cost. Can I use SUMIFS to get the total cost?

I can run a report to give me the total but need to display it in the dashboard as one number. Is there a way?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!