How do I calculated Expected Completion %


My Smartsheet rep designed a formula for me but it's no longer working. I don't know what I changed to cause the error. I am trying to calculate if a project is ahead or behind schedule.

Here is what I have that is returning the error #INVALISD DATA TYPE

Assistance is very much appreciated.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!