Multiple Formulas: Formula SUM conflicts with Formula IF Logic

Denise Quach

I have a sheet set up so that when a checkbox is checked, the price of a product generates in the column next to it. I also want to be able to capture the sum of everything in the price column, but when I input an =SUM, it reads as 0.00. Is there a way for the formula to calculate the sum of values that are generated by a different formula?

Alina Anderson

Hi Denise,

 

If you are using hierarchy (parent/child) rows, you can use the following formula: =SUM(children()) and it will capture a total of all child rows. 

 

source: http://help.smartsheet.com/customer/portal/articles/775363-using-formulas#numeric

 

 

Christine Oakes

Take the quotes away and remove the $ sign from the $38.66 in your formula. So you will be left with =IF(checkbox5 = 1, 38.66). then just format the column as Dollars. 

 

Once you put those quotes in your formula, Smartsheet identifies it as Text.

Zack S

Hello Denise, 

 

 

From your initial description, I believe that Christine’s answer will most likely resolve the issue. If you are still having troubles with the formula, please email support@smartsheet.com and let us know, and we can take further steps to investigate. 

 

-Zack 

Denise Quach

Perfect! Thank you so much, Christine!