Sign in to join the conversation:
I am having trouble with this error and need help with the formula
4 Columns (let's call them A,B, C, F)
Formula used is: =SUM(Column B + Column C)/ Column A
How do I make Column F equal Zero (0) when Column A is equal to Zero (0)
Thanks,
BM
Hi Bill,I usually wrap these in an IFERROR statement.
So it would read:
=IFERROR(SUM(([Column B]@row+ [Column C]@row) / [Column A]@row), 0)
Hope that helps!
Would the following formula do what you are looking for?
=IF(A2 = 0, 0, (B2 + C2 )/ A2)
Helloe Everyone! I’m trying to reference another sheet in Smartsheet, but I’ve noticed that sometimes it loads quickly, while other times it takes a very long time to display the list. Does anyone know why this happens? Is there a way to reduce how often this issue occurs? Today, I can’t get anything to load at all. 😑
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?
