Sum formula not working

Jeana

Trying to sum cells in a row that have value based on a formula. I've read that this can be an issue and to use VALUE in the equation. However, I'm still getting a RED Zero as a result.

Any ideas?

=VALUE(SUM([Printing and Shipping]7, [Interim Reviews]7))

Thanks

Genevieve P.

Hi Jeana,

Try wrapping the VALUE function around the actual cells referenced, versus around the formula as a whole:

=SUM(VALUE([Printing and Shipping]@row), VALUE([Interim Reviews]@row))

Here's more information on the VALUE function: https://help.smartsheet.com/function/value

I've swapped out your row reference of 7 to be @row so this should work for any row. If this is still returning 0, it would help to see screen captures of your sheet (but please block out any sensitive data), and a copy/paste of the formula returning each number. Thank you!

Cheers,

Genevieve

Genevieve P.

Hi Jeana,

Try wrapping the VALUE function around the actual cells referenced, versus around the formula as a whole:

=SUM(VALUE([Printing and Shipping]@row), VALUE([Interim Reviews]@row))

Here's more information on the VALUE function: https://help.smartsheet.com/function/value

I've swapped out your row reference of 7 to be @row so this should work for any row. If this is still returning 0, it would help to see screen captures of your sheet (but please block out any sensitive data), and a copy/paste of the formula returning each number. Thank you!

Cheers,

Genevieve

Jeana

Perfect, that's what I was missing! Thank you so much!

Genevieve P.

Great!! Glad it worked for you 🙂