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

How to Preserve INDEX Formula Data When Archiving Row?
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
2 of 5 automation workflows in a SMartSheet randomly stopped performing?
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.
How do I add horizontal lines to a stack chart for my Dashboard?
I need to add 2 horizontal lines to my stack chart to show when we have over allocated for our resources and where our average is. Does anyone know how to make this happen in a Smartsheet dashboard?