Forum Discussion

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 th...

Formulas and functions

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
------------------------------