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
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 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!