Total % Complete for 4 columns

I think this formula should be easy but I am terrible with formulas.

There are 4 columns, when there is a date = 25%, if there is no date =0% and the final column that will show total % complete for the 4 columns:

Formula I have is:

=SUM([LAN MIGRATION COMPLETE2]@rowDATE([LAN Migration Ready Actual]@row, 0.25) + IF(DATE([LAN Migration Ready Approved Actual]@row, 0.25) + IF(DATE([LAN Migration Scheduled Actual]@row, 0.25) + IF(DATE([LAN Migration Complete Actual]@row, 0.25)))))

but is wrong and I don't know how to fix it.

I appreciate any help

Thanks

Rob😙

Find more posts tagged with

Formulas

functionality

IT & Operations

Product Development

Project Management

Accepted answers

Jeff Reisman

@RobNY2 Try this:

=(COUNTIF(ISDATE([LAN Migration Ready Actual]@row)) + COUNTIF(ISDATE([LAN Migration Ready Approved Actual]@row)) + COUNTIF(ISDATE([LAN Migration Scheduled Actual]@row)) + COUNTIF(ISDATE([LAN Migration Complete Actual]@row))) / 4

This counts how many of the columns have a date value, divides the answer by 4, giving you the percentage.

All comments

Jeff Reisman

@RobNY2 Try this:

This counts how many of the columns have a date value, divides the answer by 4, giving you the percentage.

RobNY2

Thank you very much! 😀

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