Percent of checked boxes in summary fields
Hello Smartsheet world,
I have two checkbox columns and I need a formula in the summary fields that calculates the percent of students that have both checkbox columns of "Fall 2020" and "Spring 2021" checked out of the total number of students that have checked boxes in "Fall 2020" plus the total number of students that have checked boxes in "Spring 2021".
I basically need to know the number of students that returned from the Fall of 2020 to Spring 2021.
Answers
-
Try something like this...
=COUNTIFS([Fall 220]:[Fall 2020], 1, [Spring 2021]:[Spring 2021], 1) / COUNTIFS([Name (Last, First]:[Name (Last, First], @cell <> "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 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!