% complete duration
I would like to calculate duration % complete from the actual start and actual end date,
Is there a formula to calculate the duration, should be calculated based on hours (24 hours)
Answers
-
If I'm understanding you correctly, you'd like to compare the Actual End Date value with Today's Date to determine how far along a specific task is in percent, is that correct?
If so, there currently isn't a way to do this using Hours, however you can use NETWORKDAYS to compare two dates and return how many working days are between them. For example, you can find the number of working days between the Start Date and Today's Date, then divide that by the total duration in working days:
=IF([Actual Start Date]@row > TODAY(), 0, IF([Actual End Date]@row <= TODAY(), 1, NETWORKDAYS([Actual Start Date]@row, TODAY()) / NETWORKDAYS([Actual Start Date]@row, [Actual End Date]@row)))
Note that I added two statements at the beginning, so if the task hasn't started yet it's at 0%, and if the End Date is in the past (so it's complete) then it's 100%.
Let me know if this helps and is what you're looking for!
Cheers,
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!