Welcome!

#Divide by zero error

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,

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)

Back ups
Where do I go to make sure my Workspaces are being backed up? It seems that currently only one of our Workspaces is being backed up.
Update Request Errors
Hi, We’re encountering errors when attempting to open an update request via email. Please see details below. Could you advise on the cause and next steps? Thanks
Collections - can more than one person be admin?
Right now it seems as if only the person who created the Collection can share it with others - is that correct? We have a firm process tracking system in Smartsheet where some items in workspace are accessible to all and others only to certain departments. Each department has their own collection that includes a…