How can I add a colum with the Estimated percentage of progress
Currently, I have my percentage of " completed work". However I would like to know , how can I calculate the " estimated percentage of progress".
I mean. Today in one activity I have as "%Complete" an 80%, however accoring to my work plan by today in theory I should have that task at a 100%. How can I add that column to calcule the "%Estimated"?
Best Answer
-
You would use something along the lines of...
=(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row)
Answers
-
Not sure I'm following. Are you saying you would like to know the following?
-----------------------------------------------------------------------------------------
IF...
Start Date = 1/1/23
Finish Date = 1/4/23
Then
Today's Date = 1/3/23 would mean %Estimated would equal 75%
-----------------------------------------------------------------------------------------
Is that right?
-
You would use something along the lines of...
=(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!