Formula to figure out % allocated
Hi,
Is it possible to calculate % allocated based off Estimated Hours/Total Work Hours within the date range (startend dates) of the task.
For example, Task 1's Estimated hours for completion is 10hrs and the date range is 10/17/2022 to 10/21/2022.
Answers

Hi @TerryC
You could use a few functions to create calculations... for example you could use the NETWORKDAYS Function to find out how many Working Days are in your date range, then multiply this by 8 for 8 hours:
=NETWORKDAYS([Start Date]@row, [End Date]@row) * 8
This tells you the total hours given to that resource. You can then divide the Estimated Hours by this number in order to find the percent:
=[Estimated Hours]@row / (NETWORKDAYS([Start Date]@row, [End Date]@row) * 8)
So in your example above, this would return 0.25, which you could then format to be 25%.
Cheers!
Genevieve
Need more help? 👀  Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋  Global Discussions
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!