How to remove #Divide By when result is 0
Options
This is my formula and the result is zero which is accurate, however the cell is displaying #DIVIDE BY. How can I change it to show 0% vs the error?
=([Metric 1]@row / Totals@row)
Tags:
Answers

Can you put an IF statement like =IF(Totals@row = "0", "0%", ([Metric 1]@row / Totals@row)) ?

Thank you!!! Actually were able to figure it out, sharing in case anyone comes across this in the future and needs assistance.
=IFERROR(SUM([Metric 3]@row / Totals@row), "0%")
Thanks!
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!