Error Fix

Michael Stockbridge

Michael Stockbridge ✭✭

07/31/23 in Formulas and Functions

Screenshot 2023-07-31 121358.png

I'm Trying the add a Column Formula and want to add an Iferror but I can't Figure it out.

Currently have:

=(([Total Cost]@row + Crate@row + Tax@row + Freight@row) / Quantity@row)

I don't want to see #DIVIDE BY ZERO

Thank you for your help

0 ·

Answers

Paul Newcome Community Champion

07/31/23 edited 07/31/23

=IFERROR(original_formula, "")
https://help.smartsheet.com/function/iferror

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter
Razetto ✭✭✭✭✭✭

07/31/23

@Michael Stockbridge =IFERROR((([Total Cost]@row + Crate@row + Tax@row + Freight@row) / Quantity@row), "")

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

Automatically Create Status based on completed check column and finish date
I want to have a formula in my status column that makes the status "overdue" if completed column is not checked and finish date is in the past and "on schedule" if otherwise. The formula I have below is giving me a circular reference error. Current Formula: =IF(AND(Completed@row = 0, Finish@row < TODAY()), Status@row =…
Index Max / Children
Hello community, I need a formula that will return the most common value of its children. In the photo below. There are two expanded lists (Chatham and Patcham). I want my formula to capture the most common nature of issue for each location. In this example, Chatham should return 'Power Isolation Process' and Patcham…
INDEX COLLECT MAX
=INDEX(COLLECT({Nature of Issue}, {Nature of Issue Count}, MAX({Nature of Issue Count}, 1), {Site Name Helper}, Site@row), 1) Hello, community. I am trying to solve following. I want my formula (above) to return the nature of issue that has the most common nature of issue count for each site {Site name helper}. It is not…