Total Percentages Based off Check Box Selections

RJT

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")))))

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.

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.