SUM help
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
Best Answer
-
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) + ..........................................
Answers
-
Are you able to provide a screenshot for context?
-
Couple of screen shots:
I just want to be able to have a sum total if more than 1 box is checked.
Thx
-
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) + ..........................................
-
Thank you. It took me a minute, but got it working.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives