Checkbox Formula

02/09/18 Edited 12/09/19

Hi there, I have created a document designed to check off whether or not we have received scores back from our partners using a column of check boxes. I need to input a formula that counts the boxes that have been checked off versus the total number of check boxes  (ex. Scores Received: 4 out of 20)

Can someone provide a formula? Thank you!

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi, 

    Here's one way to do it by counting the children.

    ="Scores Received: " + COUNTIF(CHILDREN(Check); 1) + " Out of " + COUNT(CHILDREN())

    Would that work for you?  

    I hope this helps you!

    Best,

    Andrée Starå - Workflow Consultant / Get Done

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.