Actual % Complete vs Expected % Complete

Hey! Please, does anyone know how I can calculate the "Expected % Complete?" I have tried numerous formulas but it is not giving me the outcome that is needed. Will I need to use the "Duration" or the "Start Date" or "End Date" in any particular order?

The Formula I use to find Expected % Completed - =IFERROR(ROUND((TODAY() - [Start Date]@row) / [End Date]@row - [Start Date]@row), 2), "")


Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!