I need to calculate % Complete

StephMac ✭✭
edited 04/12/24 in Formulas and Functions

Hi, I am trying to calculate % complete with an IF formula because if it is marked complete I want it to say 100% and the current formula is tell me it is 3,098% complete because start and end date are in the past.

Old formula: =(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row)

What I am trying to write but won’t work: =IF(Status@row= “Complete”, 100%, (=TODAY()-[Start Date]@row/[End Date]@row-[Start Date]@row))

Help! How can I get this to work??


  • bisaacs
    bisaacs ✭✭✭✭✭

    Is the % completed supposed to just calculate what % of time has passed between start date and end date then?

    also, I think you'd need to remove the "=" sign in front of TODAY in the IF statement. What error are you currently getting?

    If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!

    I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!