Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
IF Statement and CheckBox
I am trying to get a sum of % completion based on a Checkbox. For example, if someone checks off 34 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...?
Comments

and the IF Statement....

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.

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

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.

Thanks Mike, that was the solution.
Doug