Sum formula not working

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
Best Answer
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Perfect, that's what I was missing! Thank you so much!
-
Great!! Glad it worked for you 🙂
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives