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.
Calculate each task's percentage completed by days gone by
Hi everyone,
I have been trying to work out how to do this using lots of threads here but don't seem to be getting anywhere.
I want to automate the percentage complete for each task, based on the dates.
So if a task has gone past its end date, it would be 100% complete.
Can anyone help?
Many thanks,
Katie
Comments
-
I have used this:
=IF((TODAY() - [Start Date]5) / Duration5 > 1, 1, IF((TODAY() - [Start Date]5) / Duration5 < 0, 0, (TODAY() - [Start Date]5) / Duration5))
And it looks like it works... I don't totally understand it, though.
-
Katie,
re: " And it looks like it works... I don't totally understand it, though."
LOL Who does, really?
You are a very trusting manager to assume, for example, that for a 5 day task, that 20% of the work is performed every day.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives