IFERROR Function

Nyasha

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

Thanks! :)

MCorbin

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

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.

MCorbin

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

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å

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!

Nyasha

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å

@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!