Summarising Data as a Metric

We run many projects using smartsheet, each project has a seperate sheet and always adding more. We would like a metric on a dashboard to show the number of x tasks due (i.e. shop drawings or site measure) It is easy enough to count this on a single sheet using sheet summaries, but as you can't select metrics from multiple sheets on the dashboard we can not get a total count of 'like' taks due.

Can anyone help?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!