IF Statement and CheckBox

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

Find more posts tagged with

Construction

Formulas

Project Management

Comments

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