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)

Using single-sign-on with external partners
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Anyone have the link to register for the Core Product Exam without the Learning Pass.
Cant find this anywhere