SUM help

BMiller828

I am a newb with smartsheet and still learning. I am building a risk assessment tool and the form for the end user has check boxes. Each box gets a specific value based on risk. So anything from one box to all of them could be checked. I need the total of all boxes checked. Here's where I am stuck:

=IF([FLIGHT PROFILE]@row = "NORMAL CALL - IN COUNTY", 1, IF([FLIGHT PROFILE]@row = "NORMAL CALL - OUT OF COUNTY", 3, IF([FLIGHT PROFILE]@row = "LANDING OFFSITE - FAMILIAR", 1, IF([FLIGHT PROFILE]@row = "LANDING OFFSITE - UNFAMILIAR", 2, IF([FLIGHT PROFILE]@row = "AIRCRAFT TRAINING / EVAL", 3, IF([FLIGHT PROFILE]@row = "MAINTENANCE TEST FLIGHT", 4, IF([FLIGHT PROFILE]@row = "SPECIALIZED - TNG, K9, SWAT, SAR", 5)))))))

When individual boxes are checked, the formula works fine. I need the sum of all boxes checked and can't figure out the formula to make that happen. Any help appreciated. Thx

Paul Newcome

Ok. Instead of nesting your IFs together, you want to "add" then together and use a HAS function.

=IF(HAS([Flight Profile]@row, "Normal Call - In Country"), 1, 0) + IF(HAS([Flight Profile]@row, "Normal Call - Out of Country"), 3, 0) + ..........................................

Paul Newcome

Are you able to provide a screenshot for context?

BMiller828

Couple of screen shots:

I just want to be able to have a sum total if more than 1 box is checked.

Thx

Paul Newcome

Ok. Instead of nesting your IFs together, you want to "add" then together and use a HAS function.

=IF(HAS([Flight Profile]@row, "Normal Call - In Country"), 1, 0) + IF(HAS([Flight Profile]@row, "Normal Call - Out of Country"), 3, 0) + ..........................................

BMiller828

Thank you. It took me a minute, but got it working.

Paul Newcome

Happy to help. 👍️