Please help with sumifs when the criteria is check boxes
Hello,
I am trying to sum a column if none of the checkboxes are checked. I have 9 checkbox columns that need to be factored in. I can get one column to work, but when I start adding more columns it will not work. I think I am missing something simple because I am frustrated.
My single column formula is =SUMIFS([RMA request $]@row, [Adjusted RMA]@row, true)
I have changed the true to a 1 as well.
In the end, I just need the "RMA Requested $" to be in the last column if nothing is checked off.
TIA
Answers
-
Hi,
What about using a Report. There you can filter out all the checkboxes that are checked and use Summarize (SUM) to get the value of RMA requests.
Will it work?
Best,
Beata
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!