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)
Missing Form Entry Help Needed. Here's my troubleshooting steps so far: Confirmed Link used is correct and it's entries land on the Form Smartsheet Confirmed no sheet filters or hidden columns Confirmed row entry nowhere on sheet, not on bottom Form shows "3 Submissions"
I am looking to have my sheet track the number of days remaining after a beginning date entered in a column (labeled Conversion Date). I need to know how many days are left from a total of 90 days.
Today Mar-18, I've lost all my tasks in gantt view, but they are still visible in card view or grid view. Yesterday i've shared the sheet with the team with view only access. Did anyone have similar issues? and how to resolve this?
