Training Database
Hi, how can I use Smartsheet to create a training database? I would like to populate it with training courses (with dates, location and cost), and then staff can vote/apply to go on those training courses. Thanks
Best Answers
-
Hi @Hakan
One way I've seen it is to list all the employees and their roles/groups down the first two columns. Then consider each training course its own section of a few columns: course name, description, cost, hyperlink, required checkbox, completed checkbox, due by date, completed date, and renewal date. So if you had 10 courses, it would 90 columns right there just for course information. It seems like a lot but with reports it can feel like less. From there you could set up all kinds of notifications and reports by role or group or who hasn't completed the training yet and is required to do so.
The other option is to have each course be its own row and then list the employees as columns. This method works for small companies that don't need a filtered list of whose done what. I like the 1st method better but I've seen this work too.
I hope those ideas help.
Thanks - Matt
-
Thank you Matt!
Answers
-
Hi @Hakan
One way I've seen it is to list all the employees and their roles/groups down the first two columns. Then consider each training course its own section of a few columns: course name, description, cost, hyperlink, required checkbox, completed checkbox, due by date, completed date, and renewal date. So if you had 10 courses, it would 90 columns right there just for course information. It seems like a lot but with reports it can feel like less. From there you could set up all kinds of notifications and reports by role or group or who hasn't completed the training yet and is required to do so.
The other option is to have each course be its own row and then list the employees as columns. This method works for small companies that don't need a filtered list of whose done what. I like the 1st method better but I've seen this work too.
I hope those ideas help.
Thanks - Matt
-
Thank you Matt!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives