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 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...?
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
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives