% Complete for Checkboxes Marked

Options

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

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!