IFERROR Function

Options

Please help me before I go completely crazy - what's wrong with this formula: =IFERROR((Complete@row / Total@row), 0)

Thanks! :)

Best Answers

  • MCorbin
    MCorbin Overachievers Alumni
    Answer ✓
    Options

    There should be nothing wrong with it. You have an extra set of parentheses which aren't needed, but it should work either way: =IFERROR(Complete@row / Total@row, 0)

    So if you are getting an error, I would check to make sure that you have the columns spelled exactly as they are in your sheet, and that the 0 at the end for the formula is in fact a zero, not a capital o

    Also, check the Column Type where you have the formula - is it a Text/number column?

    If none of those, you may want to screenshot your sheet with those columns showing.

  • Nyasha
    Nyasha ✭✭
    Answer ✓
    Options

    Many thanks, @Andree & @MCorbin - it's working fine now.

    I switched off the dependencies and also removed the extra unnecessary parenthesis - two more knowledge tips added to my database.

    Have a fantastic week!

    Nyasha.

Answers

  • MCorbin
    MCorbin Overachievers Alumni
    Answer ✓
    Options

    There should be nothing wrong with it. You have an extra set of parentheses which aren't needed, but it should work either way: =IFERROR(Complete@row / Total@row, 0)

    So if you are getting an error, I would check to make sure that you have the columns spelled exactly as they are in your sheet, and that the 0 at the end for the formula is in fact a zero, not a capital o

    Also, check the Column Type where you have the formula - is it a Text/number column?

    If none of those, you may want to screenshot your sheet with those columns showing.

  • Nyasha
    Nyasha ✭✭
    Options

    Thanks for the suggestions.

    All columns are Text/Number

    I'm not getting an error but Smartsheet is not evaluating the function - it's treating it as a text string - see screen dump below


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

    Hi @Nyasha

    I hope you're well and safe!

    To add to MCorbin's excellent advice/answer.

    You can't use formulas in the % Complete column when using the Dependencies feature.

    Was that the issue?

    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, Awesome, 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Nyasha
    Nyasha ✭✭
    Answer ✓
    Options

    Many thanks, @Andree & @MCorbin - it's working fine now.

    I switched off the dependencies and also removed the extra unnecessary parenthesis - two more knowledge tips added to my database.

    Have a fantastic week!

    Nyasha.

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

    @Nyasha

    Excellent!

    Happy to help!

    Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. 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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!