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

Options

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 ✭✭✭✭✭
    Options

    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!
  • Buckwheat
    Options

    I was looking to get a percentage of number rows populated / number of boxes checked in another column

  • J Tech
    J Tech ✭✭✭✭✭
    Options

    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!