Help with IF formula
=IF([Accident today?]@row = "0", SUM(Subtotal@row + [DC AF]560), "0")
I'm looking to solve, if there is a 0 in the Accident today? column, then to add subtotal from this row to value from 1 cell above in DC AF column
the first row after a "1" in Accident Today is returning a zero...
Best Answer

Hi Scott!
I made a mockup of the formula you showed, and for some reason anywhere the DC AF row is below a zero it has issues. When I changed the formula to:
=IF([Accident today?]@row = "0", SUM(Subtotal@row , [DC AF]560), "0")
it appeared to work just fine.
Hope that helps!
Answers

Hi Scott!
I made a mockup of the formula you showed, and for some reason anywhere the DC AF row is below a zero it has issues. When I changed the formula to:
=IF([Accident today?]@row = "0", SUM(Subtotal@row , [DC AF]560), "0")
it appeared to work just fine.
Hope that helps!

Brilliant, Thanks Sterling!!!
the small nuances between Excel formula writing and Smartsheet can be troublesome.
Help Article Resources
Categories
Check out the Formula Handbook template!