Need help please
Hi wondering if anyone can help me I have set up a smartsheet that my staff fill in via the form each day (example 1) for the amount of jobs they have completed. I created a summary sheet (example 3) which gives a count of all completed which feeds into a Dashboard, but I need to get the number for each staff member of what they have completed (example 2), I have tried a few ways but don't seem to be getting anywhere?
Example 1
Example 2
Example 3
Answers

If you have Pivot App you can get both of your examples pretty easily. If you don't have that add on there are a couple of ways to get the info....
Example 3 would likely be completed the simplest way via Sheet Summary cells for each category with a SUM Formula.... ex: SUM([Coupling / Uncoupling]:[Coupling / Uncoupling]). Once you have all of your sheet summary fields created with the formulas, you can easily use that to create dashboard widgets.
To get to the metrics in example 2  you would you SUMIF formulas. At the bottom of example 2 it looks like you have a people hierarchy in addition to the type of work. It may be easier to have the people hierarchy but then separate out the type of work by column. Otherwise, you'll need to build formulas for each individual cell rather than building one formula for each column.
If you shift to the types in each column and the people heirarchy you could use this formula
=SUMIF({reference Driver Trainer}, $[Driver/Trainer]@row, {reference column for 1st type})
The $ sign makes it so that as you copy your formula across the reference stays the same. You would need to create the second cell reference in the formula above for each column /type of work but you would only need to create the reference for the name of hte person once.
Hope this helps!
Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY business optimization product manager

Thanks Kelly got it all working now
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 379 Global Discussions
 213 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!