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")))))
Best Answer
-
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.
Answers
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!