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 not sure I understand the limit with the new type of licences. If I send an update request through a Workflow. Does the receiver need a License and edit the update request form? Thank You
I have automations circling between each other and retriggering. I cannot seem to find how it is taking place. Currently I have approval automations that are separated out in numeric order. Instead of going from one approval to the next, my trigger is a Place in Approval Process Column that changes to the next approval…
I am being asked what are the standard retention settings for Smartsheet, and are they able to be set by our company, or is this something hard set by Smartsheet? If changeable where is this set?
