Sign in to join the conversation:
HI all,
I have a sheet where I am collecting data. One is our overall variance. In certain rows I do not have data and receive the #DIVIDE BY ZERO message. I have attached the screenshot to show my formula.
Thank you,
Hi there, the issue is that your IFERROR doesn't have an open parenthesis. IF should be IFERROR( your formula , value if error).
=IFERROR([Comulative Cost]1-[Cumulative Budget]1/[Cumulative Budget]1, 0)
But you should also consider using @row instead of declaring the row number so its easier to copy/paste between rows.
=IFERROR([Comulative Cost]@row-[Cumulative Budget]@row / [Cumulative Budget]@row, 0)
It also looked like you were closing the error early in the calculation which would also cause an issue. Your entire calculation should be enclosed in there.
Did you ever get this working?
Hello, I'm encountering an issue when attempting to copy certain Smartsheet sheets. When I try to "Save As New," the process consistently times out, indicated by a spinning cogwheel. On occasion, I also receive an error message stating that Smartsheet is unavailable. This problem is not affecting all of my sheets, only a…
Is it possible for dropdowns to filter by value? For example, my dropdown options are: Solar Battery, Winter Battery, PV Panels, PV Interconnections. If I type into a cell that uses this dropdown and enter “Battery,” none of the battery options appear. But if I type “PV,” then both “PV Panels” and “PV Interconnections”…
There are several instances when I make a new column in a sheet and want to add the description. The current set up is two different functions. Can the "Add Column Description" be added to this prompt box? I use several column formulas and automated columns that are also locked. In order to "Add Column Description", I have…
