#DIVIDE BY ZERO Error - other resolutions not working

kdashnaw
kdashnaw
edited 03/24/22 in Formulas and Functions

I am trying to resolve a #DIVIDE BY ZERO error. I've seen the other resolutions, but they are not working for me. Here is the formula that I am using:

=ROUNDUP(([Anchor Install Hours]@row / {Amazon - Brownfield - Priority Sites - Set Range 2} / [# Anchor Technicians]@row), 0)

I tried the IFERROR(ROUNDUP resolution and that gave me an invalid argument.

Advice?

Best Answer

Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @kdashnaw

    I hope you're well and safe!

    Try something like this.

    =
    IFERROR(ROUNDUP([Anchor Install Hours]@row / 
    {Amazon - Brownfield - Priority Sites - Set Range 2} / [# Anchor Technicians]@row), 0)
    ,"ERROR MESSAGE")
    

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • kdashnaw
    kdashnaw
    Answer ✓

    @Andrée Starå Thank you so much for the quick response and assistance! This formula works now!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    @kdashnaw

    Excellent!

    You're more than welcome!

    Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Help Article Resources