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.
Project Management: Weekly capture of actuals against planned hours
Many thanks in advance!
We have a team of project associates that are asisgned to a number of tasks on a project in a smartsheet. I want to be able to send a timesheet to each resource at the end of every week. On the timesheet I would like to display the task for the week and ask for actual hours to be entered. These hours i would capture by person, week ending. in a report to be used for invoicing. This is a simple timesheet capture mechanism against an existing project plan.
Has anyone figured out an approach to this ?
Thanks again!
Comments
-
The reporting tool can be used to pull in all the tasks assigned to a specific user in a given timeframe. You cannot build formulas in a report but if you have a formula in your sheet that sums all the hours a user worked in a given timeframe, you can include that row/formula in your report to show all the tasks a user did in a week and a sum of the hours worked. Here is info on reports: http://help.smartsheet.com/customer/portal/articles/522214-creating-reports
-
Any progress on this one? I have the same need and haven't been able to fin a way in Smartsheet. We use a tool called Harvest
-
Hi David, looks like the post has been out there for a while but I’m super interested to know if you found a good answer? I’m struggling with the same issue. Thanks in advance.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives