Need a report that summarizes clients assigned to staff
I have a very basic Smart Sheet:
Staff Member (Contact List)
Client name (Text Column)
Age (Date)
Birthday (Date)
There are a few other columns, but they are not relevant to my question. I need to be able to run a report that summarizes the number of clients assigned to each Staff Member. I don't need to know anything about the client, just a summary by Staff member. Literally...
Staff member A = 5
Staff member B = 10
But I can't figure out where to find the formulas when building a Report???
Best Answers
-
Reports don't have any functionality for formulas, etc. They are just a view only summary of the data. If you want to do calculations, you need to do it in the sheet - either in a cell, or in the sheet Summary (which is this little button on the right hand side of the sheet )
I would use the sheet Summary and then create the report to look at the summary. Click the Summary button and add a new field for each Staff Member with the following formula:
=COUNTIF([Client name]:[Client name], "Bob")
where "Bob" is replaced with the name of the person.
Then when you create the report, select Summary Report and point it at the sheet. It will look at the Summary data instead of all the data in the cells.
I used the above to count the number of projects assigned to each PM on my team.
-
Bob,
Thank you. Very helpful, and it will get the job done!
Answers
-
Reports don't have any functionality for formulas, etc. They are just a view only summary of the data. If you want to do calculations, you need to do it in the sheet - either in a cell, or in the sheet Summary (which is this little button on the right hand side of the sheet )
I would use the sheet Summary and then create the report to look at the summary. Click the Summary button and add a new field for each Staff Member with the following formula:
=COUNTIF([Client name]:[Client name], "Bob")
where "Bob" is replaced with the name of the person.
Then when you create the report, select Summary Report and point it at the sheet. It will look at the Summary data instead of all the data in the cells.
I used the above to count the number of projects assigned to each PM on my team.
-
Bob,
Thank you. Very helpful, and it will get the job done!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives