Looking to add a percentage complete calculation

azandy77

Hello,

I'm trying to have Smartsheet calculate the percentage of the project complete based on the number of checkboxes marked. I want to be able to take that figure and add it as a metric widget. I only have this created so far. =IF(Completed1 = 1, "Yes", "No"

Thanks

Michael Drayton

Hello @azandy77 I think this will work for you.

=COUNTIF({Checkbox Column Name Range1}, 1) / COUNT({Checkbox Column Name Range1}) * 100. Let me know how it turned out. :-)

Good luck!!