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
-
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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!