Discussions

Expand all | Collapse all

Field to count number of checkboxes ticked against remaining

  • 1.  Field to count number of checkboxes ticked against remaining

    Posted 6 days ago
    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
    ------------------------------


  • 2.  RE: Field to count number of checkboxes ticked against remaining

    Posted 6 days ago
    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
    ------------------------------



  • 3.  RE: Field to count number of checkboxes ticked against remaining

    Posted 6 days ago
    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
    ------------------------------