Adding Checkboxes

smcelvany ✭✭
edited 12/09/19 in Formulas and Functions

I am trying to created check point progress with check boxes and a visual aid. I created a If formula, but my progress is not adding up. I would like to know if anyone can help me with a better formula. 

Check boxes.PNG


  • smcelvany

    =IF([Classes Complete l]2 = 1, "Quarter", IF([Classes Complete ll]2 = 1, "Three Quarter", IF([Classes Complete lll]2 = 1, "Full")))

    This is the formula. I am using, but its not working. 


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


    Try something like this.

    Starting with the last one first because the formula will stop when something is true.

    =IF([Classes Complete III]@row = 1; "Full"; IF([Classes Complete II]@row = 1; "Three Quarter"; IF([Classes Complete I]@row = 1; "Quarter")))

    The same version but with the below changes for your and others convenience.

    =IF([Classes Complete III]@row = 1, "Full", IF([Classes Complete II]@row = 1, "Three Quarter", IF([Classes Complete I]@row = 1, "Quarter")))

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    Did it work?

    Hope that helps!

    Have a fantastic weekend!


    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD


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

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!