IfError Formula

Sarah Johnston

Sarah Johnston ✭✭

10/22/19 edited 12/09/19 in Formulas and Functions

Hello,

I have the formula but would like to add the IfError to it to avoid the #DIVIDE BY ZERO - any suggestions?

=[2018/2019 Sales]1 / [Square Feet]1

Tags:

Formulas

0 ·

Comments

Mike Wilday Community Champion

10/22/19

Try this.

=IFERROR([2018/2019 Sales]1 / [Square Feet]1, 0)

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How to copy a row with values not formulas
Hello, I have an automation on a sheet to copy a row to another sheet each day. The automation works. My issue is that it copies formulas and they all break and return errors. How can I copy a row but have it copy values instead of formulas? Below is the Automation This is the original sheet This is the sheet where it is…
HOW TO USE COUNTIF BETWEEN SHEETS?
Hi, i have a sheet (pictured below), that has a "machine / equipment" column that corresponds to a second sheet. in my second sheet i would like to use count if to count the number rows that exist where the "machine/equipment are the same or match. below i tried 2 formulas but they wont work. Any ideas??…
Help with COUNTIFS with multiple criteria in same range, where to put the OR operator
This is a frequent topic in the smartsheet community, and I think I've read most of the responses, but I can't resolve it for my particular situation. : ( Mostly I get unparseable when I add my OR criterion. This is used on a project portfolio metrics sheet, where I want to count for each particular calendar year how many…