Calculate the percent of boxes checked from the number of rows populated

Is there away to calculate the percent of boxes checked from the number of rows with data in them? But the number of rows with data populated will be different every time we import the data to the sheet.

Answers

  • J Tech
    J Tech ✭✭✭✭✭

    Hi,

    In the sheet summary, create a new field / or use existing:

    • Field Type: Text/Number

    =COUNTIF([Checkbox Column]:[Checkbox Column], true) / COUNTIF([Primary Column]:[Primary Column],

    Please replace field names with the names in your sheet.

    Trust this is useful.

    Regards

    J Tech

    If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
  • I was looking to get a percentage of number rows populated / number of boxes checked in another column

  • J Tech
    J Tech ✭✭✭✭✭

    Thats ok,


    =COUNTIF([Primary Column]:[Primary Column]/COUNTIF([Checkbox Column]:[Checkbox Column], true)


    Regards

    J Tech

    If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!