I need to calculate % Complete

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??
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!