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
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!