How do you use SUM with cells that contain formulas?

kmalone51256

I am trying to add a selection of cells that contain an "IF" formula using the "SUM" formula, but it doesn't seem to be recognizing the value that the formula returned. Is there a way to do this in Smartsheet?

Community SUMIF Question.png

Leibel S

@kmalone51256

Your IF formula is putting in the text "4" as opposed to the number...

Change it to:

IF(Status@row="Completed",4)

Leibel S

@kmalone51256

Your IF formula is putting in the text "4" as opposed to the number...

Change it to:

IF(Status@row="Completed",4)

kmalone51256

This is awesome!!! So simple :) I learned something new today. Everything works now with what I want to do.