Forum Discussion

JessicaMatenga's avatar
JessicaMatenga
Qrew Trainee
4 years ago

Field to count number of checkboxes ticked against remaining

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
------------------------------
Formulas and functions
  • SeanBoat-Moore's avatar
    SeanBoat-Moore
    Qrew Trainee
    4 years 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
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years 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
    ------------------------------