Welcome!

How to eliminate Divide by Zero error from IF formula

I have a "Divide by Zero" error that I can't seem to get rid of.

=IF(Percentage3 = "overstaffed", [Column8]3 / Ordered3, Received3 / Ordered3)

Not sure where to place the IFERROR into this formula to ensure that I don't get the error to pop up.

Screen Shot 2019-05-09 at 6.55.42 PM.png

Hi Jed,

Place the IFERROR at the front, i.e.

=IFERROR(IF(Percentage3 = "overstaffed", [Column8]3 / Ordered3, Received3 / Ordered3), "")

This will replace the error message with null.

I hope this helps,

Sean

Master Project Plan
I have a massive project that spans across multiple regions. I want to segregate my plan into region sheets so when I update each individual plan the master plan will be updated. How can I do this?
Can automated email come from a specific email address?
We created a tracker for the Records Management team and need all emails coming from the tracker to come from the email address associated with the team. Is there a way to have all emails come from this specific email? I see options for the owner or from general smartsheet but not an option to have it come from a different…
Burn Down chart with Work Insights
Hello, I was not able to find any example on how to set up smartsheet work insight to obtain a burn down chart. Could someone share how you've done it? The tutorial provided by smartsheet is vague and does not bear results. And, no examples on Youtube either. I saw one person asking the same question a couple years ago and…