Trying to find out how many records each employee is entering per day.
My employees (9) are entering records in the field in SmartSheets. What I am trying to figure out is if there is a way that I can look at each employee's productivity (i.e. records entered), by day, in SmartSheets.
I reached out to SmartSheets for help, and they were not helpful.
Can anyone tell me if this is possible, and if so, how to actually get the data (i.e. what is the actual formula, etc.)
Thank you!
Answers
-
Hello @J.D. Landry - Do you have an auto-populating column for "Created by" and "Created date"? Using those, you can see who is entering what and when. For instance, you could set up a Report based on the sheets where they enter this data, and choose to Group by the "Created by" column. You can schedule Reports to email you with a PDF or Microsoft Excel file, so you could get the list emailed to you every day.
Does that help?
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!