Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Depending on the number of check boxes chosen add them.

edited 12/09/19 in Smartsheet Basics

I have 5 columns with Checkboxes and one with % Complete, I need the %column to show the values added up depending on the number of check boxes chosen, so if there are 3 checked boxes, it should show 60% complete. Can you help? Thanks

See screen shot attached

% Complete.PNG

Comments

  • Community Champion

    Format the completed column as percentages and use the following formula which counts each column if it's checked and then divides it by 5 which is the possible number of answers. 

    =countif([Phase 1 - Pre-Screen]1:[Phase 5 - Product Launched], 1)/5

     

  • It does not seem to give a "20%" value on each of the columns that are checked, these should add up to a 100% if all were checked. when I remove a check the % complete should change as well, but it does not. 

  • Community Champion

    What do you get when you do this... 

    =countif([Phase 1 - Pre-Screen]1:[Phase 5 - Product Launched], 1)

    Does that number change based on how many you click?

    When you have them all clicked what is the final number? 

    When you have that number replace x in this formula with that number. 

    =countif([Phase 1 - Pre-Screen]1:[Phase 5 - Product Launched], 1) / x

    I've attached a screenshot of my formula and an animated gif of it working. 

    2018-04-03_11-02-58.gif

    2018-04-03_11-01-45.jpg

  • Community Champion

    If you are seeing a decimal number... .02, .04, .06, .08 or 1 its because you haven't formatted that cell or column as a percentage. Do that by highlighting the column and clicking the % sign in the left-hand toolbar. 

  • Hi Mike, yup that worked, I gues after building and rebuilding formulas over and over in the same cell you need to clear it out and delete it. Then start over and not copy and paste but type it out and it worked. Thanks Bro

  • Community Champion

    Glad that worked out for you. 

Trending in Smartsheet Basics