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.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives