=IFERROR Issue
Options
RingJake
✭✭✭✭✭
Hello,
I have an arithmetic formula that sometimes gives me a number, and other times does not depending on if the [Completed Milestone by Month] columns are populated.
When they are not populated they result in an error "Divide by Zero", which is fine. However I'd rather this not display on my dashboard. I've tried wrapping this in an IFERROR function, but it takes the bracket required to perform the division.
=([Completed Milestones by Month]3 - [Completed Milestones by Month]@row) / [Completed Milestones by Month]
=IFERROR([Completed Milestones by Month]3 - [Completed Milestones by Month]@row) / [Completed Milestones by Month], "-")
Tags:
Answers
-
You need to add another opening parenthesis after the IFERROR function.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!