Sign in to join the conversation:
I have a "Divide by Zero" error that I can't seem to get rid of.
=IF(Percentage3 = "overstaffed", [Column8]3 / Ordered3, Received3 / Ordered3)
Not sure where to place the IFERROR into this formula to ensure that I don't get the error to pop up.
Hi Jed,
Place the IFERROR at the front, i.e.
=IFERROR(IF(Percentage3 = "overstaffed", [Column8]3 / Ordered3, Received3 / Ordered3), "")
This will replace the error message with null.
I hope this helps,
Sean
Hi all - I have a report that includes a symbol column type. The report is displaying the column correctly (with the symbol). However when I create a Dynamic View from this report, instead of that column displaying symbols, it displays text. Is there a way to get symbols to display in Dynamic view?
Does Smartsheet have the capability to create business process flowcharts or process documents? Im looking for something similar to Vizio or lucid chart?
My manager has asked me to put a border around all of my metric widgets in my dashboard. I cannot figure a way to do this. I tried creating a jpg. of an unfilled rectangle and bring in as an image. But I could not get the widgets to stay on top of the reectangle. Any ideas?
