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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!