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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives