IF Statement and CheckBox

Doug B

I am trying to get a sum of % completion based on a Checkbox.  For example, if someone checks off 3-4 of the boxes, and I know the weighting for each box (as shown in the IF statement, I would like to have a sum at the end as per the screenshot.  The problem is, the sum isn't working.  Any thoughts...? 

 

Doug B

and the IF Statement....

Mike Wilday

Based on the information here: https://help.smartsheet.com/function/sum You will need to sum each number separately. =Sum(MIll3, [Floor Jig]3, [Under Sheeted]3)

That should sum it up for you. 

Doug B

Thanks for the note.  Still getting the wrong sum and even tried adding it manually.  It's just displaying the number sequence.... odd....?

Mike Wilday

Oh... try this, =Sum(Value(Mill3), Value([Floor Jig]3), Value([Undersheeted]3, Value([Flipped & insulating]3)

Value will take the value of the number being produced in your original IF statement. 

Doug B

Thanks Mike, that was the solution. 

Doug