Help with IF formula

Scott Johnson

=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...

Sterling

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!

Sterling

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!

Scott Johnson

Brilliant, Thanks Sterling!!!

the small nuances between Excel formula writing and Smartsheet can be troublesome.