Percent complete is showing more 100%

Cody_Gomez32

The formula works, but it is still calculating after the finish date is met. How can I stop that from happening? Below is the current formula I am running.

=IF(ISBLANK([Estimated Start]@row), 0, (TODAY() - [Estimated Start]@row) / ([Estimated Finish]@row - [Estimated Start]@row))

Thank you,

Paul Newcome

Try this:

=MIN(IF(ISBLANK([Estimated Start]@row), 0, (TODAY() - [Estimated Start]@row) / ([Estimated Finish]@row - [Estimated Start]@row)), 1)

Paul Newcome

Try this:

=MIN(IF(ISBLANK([Estimated Start]@row), 0, (TODAY() - [Estimated Start]@row) / ([Estimated Finish]@row - [Estimated Start]@row)), 1)

Mike TV

@Cody_Gomez32

Can you add or maybe already have a column which designates the task as complete? Then you could add something like:

=IF(ISBLANK([Estimated Start]@row), 0, IF(Status@row <> "Complete", (TODAY() - [Estimated Start]@row) / ([Estimated Finish]@row - [Estimated Start]@row), "")

Cody_Gomez32

@Paul Newcome Thanks for your help on this! That is what it needed.