COUNTIFS Formula for % Complete with Dates and Check Boxes

We are trying to create a formula to calculate percentage complete based on specific criteria met in multiple columns within a Sheet Summary to build a Dashboard.

The formula we created is as follows: =(COUNTIFS([45-Day Check-in Mark]:[45-Day Check-in Mark], <TODAY(), [45-Day Check-in Complete]:[45-Day Check-in Complete], =1, [45-Day Check-in Mark]:[45-Day Check-in Mark], <>"")) / (COUNT([Training End Date]:[Training End Date]))

Our goal is for the formula to calculate percentage complete for onboarding check-ins at Two Weeks, 45-days, and more! We however, need to the % complete to not include in the total when no date is listed a column and the check box in another column is unchecked.

Find more posts tagged with

Accepted answers

All comments

SteyJ

it looks like your current formula is correct, but you would need to add an IF statement before to check for whether date is not present, it also looks like you might need to nest the IF, or IF(AND, to check for the checkbox + date prior to the COUNT functions.

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.