Question on using "IF", "AND", & "SUM" functions together.
I am trying to create a semicomplex formula. I have two check boxes. When someone clicks check box "A", it sums up specific columns. When someone clicks check box "B", it sums up the other columns. When someone clicks both "A" and "B" check boxes, it'll sum up all of the columns. I was able to get the individual parts working, but not when someone clicks both "A" and "B" columns.
Here is the formula I have set up: (I've edited the column slightly to use more neutral terms):
=IF(AND([Box A]@row = "true", [Box B]@row = "true"), =SUM(Column3:Column11), "false")
I am able to get the individual parts working, but I am getting an #invalidoperations when putting it all together.
For example, if I replace the sum function with ' "true" ' or something simple instead, the sheet is able to read when I have both columns clicked, and therefore will spit out "true." But when the sum formula is in place, it spits out #Invalidoperations.
Could someone help explain why this might be the case? I've already double checked to make sure all the columns are reading as numbers and not text.
Best Answer

You have a second = in your formula try
=IF(AND([Box A]@row = "true", [Box B]@row = "true"), SUM(Column3:Column11), "false")
Answers

You have a second = in your formula try
=IF(AND([Box A]@row = "true", [Box B]@row = "true"), SUM(Column3:Column11), "false")

@Hollie Green Ha. That worked! Thank you so much!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!