% Complete for Checkboxes Marked
Hello, I've looked into similar questions, but I'm struggling in how to write the formula for this. I'd like to calculate % complete of checkboxes marked for each column. Then I plan to represent the % complete in either a dashboard for reporting purposes. From what I read, it should be the =countif formula, but cannot seem to figure out. I appreciate the help!
Answers

Hi @GiselleF,
You can use a formula like this:
=COUNTIF([Ann Arbour Terminal 1]:[Ann Arbour Terminal 1], 1) / COUNT(Date:Date)
For the other terminals just adjust the column name in the COUNTIF.
This will give you a decimal number which you can convert to a decimal in a column using the button in the toolbar, or you can adjust the formula slightly if you want it directly (for example, in a sheet summary) like so:
=(COUNTIF([Ann Arbour Terminal 1]:[Ann Arbour Terminal 1], 1) / COUNT(Date:Date)) * 100 + "%"
Hope this helps, but post if you have any problems/questions!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 377 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!