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 planstart)
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 CA / BA), 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
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!