Expected % Complete
I'm attempting to have an "expected % complete" column, and have it working correctly using this formula
=IF([Start Date]@row < TODAY(), (TODAY() - [Start Date]@row) / ([Finish Date]@row - [Start Date]@row), 0)
However, I want the max return value to be 100% (I.e., not 145% if the finish date is in the past). How do I calculate that? I'm at a loss...
Help Article Resources
Check out the Formula Handbook template!