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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Perfect, that's what I was missing! Thank you so much!
-
Great!! Glad it worked for you 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 370 Global Discussions
- 202 Industry Talk
- 433 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 280 Events
- 31 Webinars
- 7.3K Forum Archives