Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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?
I am using Smartsheet on an Individual (Pro) plan. The red unread conversation indicators on rows no longer clear after I open and read the row conversations. I have already tried: Opening every conversation and scrolling through all comments. Using Mark all as read. Refreshing the sheet. Hard refresh (Ctrl + F5). Testing…
I have two sheets that use the exact same workflow: Trigger: When rows added/changed When checkbox - checked Send to contact in a cell Then record date In one sheet the workflow works as intended. In the other, the workflow appears to work (date is recorded) but no notification is received. I have already confirmed that…
Hello. I am currently making a form to track events associated with current locations. These locations will be referred to by their unique, 5 digit ID; however, this form will be used by many different people in and outside the organization, so I would also like to display the physical location so people can double check…
