Calculate percentage complete on a project based on time elapsed

I need help to finish a schedule for projects based on time elapsed. The current formula that I am trying to use has a Datedif formula but I don't think Smartsheet supports that. Any ideas or assistance would be helpful?

=DATEDIF([Projected Start Date]@row, [Projected Finish Date]@row,[Actual Finish Date]@row)/DATEDIF([Projected Start Date]@row,[Projected Finish Date]@row,[Actual Finish Date]@row)

Find more posts tagged with

Formulas

Project Management

Accepted answers

All comments

Bassam Khalil

Hi @Linda F

Hope you are fine, try to use the following formula

=(TODAY() - Start@row) / (Finish@row - Start@row)

Linda F

Hi Bassam

Thank you for your suggestion - =(TODAY() - [Actual Start Date]@row) / ([Actual Finish Date]@row - [Actual Start Date]@row)

It gave me an # DIVIDE BY ZERO message. The formula is above that I used. Is it brackets that caused the error?

Shelby

@Linda F

Here's what worked for me:

=NETWORKDAYS([Start Date]@row, TODAY()) / Duration

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.