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:
I am having trouble with this error and need help with the formula
4 Columns (let's call them A,B, C, F)
Formula used is: =SUM(Column B + Column C)/ Column A
How do I make Column F equal Zero (0) when Column A is equal to Zero (0)
Thanks,
BM
Hi Bill,I usually wrap these in an IFERROR statement.
So it would read:
=IFERROR(SUM(([Column B]@row+ [Column C]@row) / [Column A]@row), 0)
Hope that helps!
Would the following formula do what you are looking for?
=IF(A2 = 0, 0, (B2 + C2 )/ A2)
Is anyone else experiencing this issue today (7/28/2026)? Every time an automated email triggers on its own today, whether it's a regular alert, update request, etc, the values that usually appear when the automation workflow includes a field in curly brackets (ex: {{First Name}}) appears as a weird alphanumeric value in…
Hi - Is anyone else having problems with placeholder fields in update request automations today? I've been notified by my staff that our automations today are showing random text strings instead of the field data that they are supposed to. For example, in one of my sheets, there's an automations thatis supposed to show a…
Hello to all the community, my team is experiencing an issue with the notifications in Smartsheet. In the last hour the notifications started including only the placeholders of the columns, instead of the content of the related cell. I checked with the support and this could be related to changes in the workflow or in the…
