Total Percentages Based off Check Box Selections

Good Morning Smartsheet Community,

I am trying to calculate % based off check boxes selected on each row. Below are the fields I am calculating and the formula being utilized.

Formula For %:

=COUNT(Construction@row:Security@row, 1) / COUNT(Construction@row:Security@row)

(With this formula I seem to be getting 117% with the boxes unchecked. I am trying to ensure that that the percentage will increment appropriately when a box is checked eventually reaching 100%. ) Any help would be appreciated.

Progress Bar:

=IF(COUNTIFS(Construction@row:Security@row, 1) < 1, "Empty", IF(COUNTIFS(Construction@row:Security@row, 1) < 3, "Quarter", IF(COUNTIFS(Construction@row:Security@row, 1) = 3, "Half", IF(COUNTIFS(Construction@row:Security@row, 1) < 6, "Three Quarter", IF(COUNTIFS(Construction@row:Security@row, 1) = 6, "Full")))))

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

=COUNTIFS(Construction@row:Security@row, @cell = 1) / COUNTIFS(Construction@row:Security@row, OR(@cell = 1, @cell <> 1))

Then base your nested IF statement for the progress bar off of the percentage output above.

All comments

Paul Newcome

Try this:

=COUNTIFS(Construction@row:Security@row, @cell = 1) / COUNTIFS(Construction@row:Security@row, OR(@cell = 1, @cell <> 1))

Then base your nested IF statement for the progress bar off of the percentage output above.

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.