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??

Find more posts tagged with

Workspaces

Formulas

Support

Project Management

Resource Management

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.