Formula to calculate expected percent completion without start date
Hi, I am not sure if this is possible but I am trying to calculate a percent completion based on a target date.
I want to determine how many entities should be completed by a max target date.
If the maximum target date is 12/15/22 I want to calculate how many entities/what percentage of entities are expected to be completed to date.
Answers
-
Hi Melissa,
You could do this with 2 "days QTY" columns (1x eoy2022>-start & 1x plan-start)
In your "expected percent complete" set the formula to divide both of these columns (EOY Days QTY / Plan Days Qty)>set to %>right click and set as column formula.
-
@Just_Chris I am not following what formula would be in each column
I've added the 2 columns: EOY Days Qty and Plan Days Qty
-
Hi Melissa here what I meant:
You can replace the last 3 columns with 1 if you want (=columns C-A / B-A), I wrote all columns in to make it more clear.
Set column C to EOY 2022 by using an automation (so you dont have to copy the date down always again).
Let me know what you think
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 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!