Tracking Hours of Effort
I have a column that tracks Actual Start date and a second column that tracks Actual Finish date. I need a formula to track Hours of Effort. Considering each day has 8-hour period, what would be the best formula to add to Hours of Effort column? Thanks!
Best Answer
-
Hi Glenn,
You could use the NETORKDAYS function to count the days from Start to End (not including weekends) then multiply this number by 8 to calculate the hours.
Try this:
=(NETWORKDAYS([Actual Start Date]@row, [Actual Finish Date]@row) * 8)
Keep in mind that the names [in these] must match your column names exactly. Let me know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi Glenn,
You could use the NETORKDAYS function to count the days from Start to End (not including weekends) then multiply this number by 8 to calculate the hours.
Try this:
=(NETWORKDAYS([Actual Start Date]@row, [Actual Finish Date]@row) * 8)
Keep in mind that the names [in these] must match your column names exactly. Let me know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks, Genevieve...much appreciated!
-
Does Smartsheet have the ability to simply add the hrs of effort available for a task? (especially when it is a fixed-price project)
I see we can add duration - which is useful for planning your schedule but not very helpful in tracking actual hrs versus planned hours (hence margin on the project)
Thanks
-
Hi @Perspect
You can add hours into the Duration column (see: Work with Duration and Predecessors)
However if you're looking to track hours and resources, I would recommend using Resource Management and connect your sheet with the Resource Management Panel.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
hmmm
These are very different attributes and we want to track both as the duration drives predecessors - whereas effort drives budget and resourcing
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!