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 created an educational tool for our study teams to guide them in meeting Clinical Trial Transparency Best Practices. I've confirmed that I can publish a sheet with all columns and rows locked except for one cell. This cell has a dropdown column that is updated nightly via a data shuttle. People with access to this…
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…
