Skip to main content
Question

Field to count number of checkboxes ticked against remaining

  • October 12, 2021
  • 0 replies
  • 33 views
Hi
I have a checklist assigned to individual checkboxes.  I would like to have a summary of the checkboxes checked against checkboxes remaining. i.e. if I had 20 checkboxes and 5 have been checked then just a summary showing 5/20

------------------------------
Jessica Matenga
------------------------------
This topic has been closed for replies.

SeanBoatMoore
Forum|alt.badge.img+5
As long as the number of checkboxes is fixed you can do a formula numeric that shows # of remaining using if statements:
20-if([checkbox1]=true,1,0)-if([checkbox2]=true,1,0)​ etc

------------------------------
Sean Boat-Moore
Manager SMB Development
Project Management Office and Quality Control
NCR Corporation
sean.boat-moore@ncr.com | ncr.com
------------------------------
Sean Boat-Moore Manager SMB Development Project Management Office and Quality Control NCR Corporation sean.boat-moore@ncr.com | ncr.com
MarkShnierYou
Forum|alt.badge.img+24
Try Something like this

var number CheckboxCount=
Count(
[checkbox 1],
[checkbox 2],
[checkbox 3],
etc ...
[checkbox 20]);

ToText($CheckboxCount) & "/20"

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement