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

  • Sterling
    Sterling ✭✭
    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

  • Sterling
    Sterling ✭✭
    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!

  • Brilliant, Thanks Sterling!!!

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!