% Complete Question

Hi, I am fairly new to SmartSheet and been looking for help, but can't seem to find what I am looking for, I have tried a similar formula I saw on here, but I can't get it to work.

I need a simple formula to show how far along a project is in %, based on dates or no of days.

I have fudged it for now with a traditional excel formula but it's not a long term fix and I have no doubt given myself more work.

I have a start date / finish date / today date / duration of project / number of days into the project.

But I also want it to show % completed and if the project hasn't started I need it to say "Not Started".

Can anyone help me please?

Find more posts tagged with

Accepted answers

All comments

bisaacs

Hey @Caroline Dunnell,

Something like this might work:

=IF([Start Date]@row = "", "Not Started", NETWORKDAY(TODAY(), [End Date]@row) / NETWORKDAY([Start Date]@row, TODAY()))

This formula only calculates based on business days and doesn't include weekends. If you want it to include weekends you can use this:

=IF([Start Date]@row = "", "Not Started", NETDAYs(TODAY(), [End Date]@row) / NETDAYs([Start Date]@row, TODAY()))

Hope this helps!

Caroline Dunnell

Thanks for your help - I have tried this and it has 397% for a project that should be 19.7%". This is what I put in based on the column titles

=IF([MOBILISATION DATE]@row ="", "Not Started", NETDAYs(TODAY(),[ESTIMATION COMPLETION DATE]@row)/NETDAYs([MOBILISATION DATE]@row,TODAY()))

Did I get something wrong?

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.