IF Error Add to Formula

Kaleb

Hello All:

I would like to ad IFERROR to the Below Formula so when the Stories is 0, I do not get a #DIVIDE Error. =$Stories$11 Represent the Total

=$Stories$11 / Stories@row

Thanks

Brent Wilson

You probably don't want an IFERROR as that is more for trapping errors

Try this

= IF(Stories@row=0, [Stories]11,[Stories]11 / Stories@row)

Kelly Moore

Hey @Kaleb

=IFERROR($Stories$11 / Stories@row,"")

As written above, the "" at the end will make the cell blank if an error occurs. If you wish to display something else, enter text in between the quotes, if you want to enter a number, eg zero, enter the value after the comma and in place of all quotes.

There is a way to convert your formula above to a column formula. This will allow the formula to always automatically be added to any new row.

Create a summary field (right hand menu ribbon) and have the field = $Stories$11

replace the $Stories$11 in the formula above with the summary field you just created (the reference for the summary field is Summary field name followed by pound sign).

Kelly

Kaleb

https://community.smartsheet.com/discussion/comment/336067#Comment_336067

I Missed the quotes. Got it, Thanks.

Kelly Moore

Great! If you need any more instruction on the Summary field, let us know. Using the summary field in your formula would make your formula much more robust.

Kelly

Kaleb

https://community.smartsheet.com/discussion/93201/if-error-add-to-formula

My Second Row Results is 500%. It Should 0%

Kelly Moore

Can you share a screenshot please. As Brent was pointing out, IFERROR only works if there is an error. A 'False' statement is not an error.

Kelly