IF Error Add to Formula

Kaleb · 07/13/22

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 · 07/14/22

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 · 07/14/22

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 · 07/14/22

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

I Missed the quotes. Got it, Thanks.

Kelly Moore · 07/14/22

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 · 07/14/22

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

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

Kelly Moore · 07/14/22

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

IF Error Add to Formula

Answers

Help Article Resources

Categories