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.
=VALUE(SUM([Printing and Shipping]7, [Interim Reviews]7))
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!
Perfect, that's what I was missing! Thank you so much!
Great!! Glad it worked for you 🙂
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.