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)
I was given editing permissions this morning but when I open the sheet it still says I am View Only.
Hi I'm trying to make indent for 78 groups, is there a way to make it in one click or I need to do it one by one. see image below, e.g., I want contioue up to B-78, and that takes a lot f time. Any suggestion?
Hello, I’m writing to request assistance regarding automation notification emails in Smartsheet. Issue: I have an automation set up to notify people when I need jobs scheduled. However, instead of sending a separate email for each job/row, Smartsheet combines multiple notifications into a single, grouped email. This makes…
