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
10xViz.com
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

Help with Health Formula
When I put this formula: =IF([% Complete]@row = "100%", "Green", IF(AND([% Complete]@row <> "100%", [Due Date]@row >= TODAY()), "Yellow", IF(AND([% Complete]@row <> "100%", [Due Date]@row < TODAY()), "Red", ""))) The status shows Red when the % complete is 100% and the Due date is past. How can I correct that? Thanks
How to get my numbers to correctly add up?!
Hello everyone, I am tasked with tracking budget moving forward and would like to be able to track overall budget but also budget for each POs. I would like to have the formula to add the Children's Children's (if that makes sense) and ignore the Total of the PO. This way I can have the total of the PO's in one line but…
Owner not able to open newly created worksheets
I just created a new worksheet, where I am the owner of a workspace, and I'm getting this error below. Anyone know why?