Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Engineer's timesheet
Has anyone created a timesheet for tracking/recording billable hours towards specific projects.
Comments
-
I am interested in the same fuctionality.
-
Hi Eddie
we use this for all our consulting and support work.
Depending on the design and whether you want each worker to ONLY see their own work, so you have some choices.....
1. Create a timesheet for each person and let them add times to their sheet but choose from a Client Project dropdown list (for uniformity). When you approve their times in their sheet, copy those rows to a master sheet where you do all your calcs, (not visible to the rest of your team) .
Use formulae to sum times and money against the projects in a dashboard area then link the resultant stats to the Project sheets by cell linking. then use that Master Project sheet to issue your invoices to clients. The individual timesheets are the basis for wages to be paid.
2. You COULD use Smart forms for timesheet entry, same form for everyone, but if they make a mistake they have no way to correct it, except email you to do so? That can work well and is easier to admin?
Hope that helps, it is a common requirement and there are even more ways to achieve this but those two are popular.
RichardR
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