Formula for %Complete Column (or progress bar) for 5+ Checkboxes columns

Hi!

I am looking for a formula to either give a percentage complete or similiar from a number of checkboxes.

I have tried;

=COUNTIFS([T1]@row1]:[T7]@row1],=1) - results in UNPARSEABLE

=COUNTIF([T1]2:[T7]2, "True") / COUNT([T1]2:[T7]2) = 0

=COUNTIF([T1]2:[T7]2) / COUNT([T1]2:[T7]2) = incorrect argument set

Find more posts tagged with

Accepted answers

All comments

Hi @Emma1516156165,

The formula to use here for counting the checkboxes is:

=COUNTIF([T1]@row:[T7]@row, 1)

If each stage is equally weighted, then you can add a divisor and make your column a percentage with this formula:

=COUNTIF([T1]@row:[T7]@row, 1)/7

Example:

Hope this helps - if you've any questions then just ask! 😊

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.