Simple subtraction formula not working when number goes negative?
Hey, im trying to create a formula where my sum will at times go negative. the plan is to highlight cells that go lower than zero.
For some reason the calculation is wrong.
62195 - 72000 should =-9805
the result im getting in smartsheet is 4195
anybody know where i went wrong?
Best Answer
-
i opened up a case with smartsheet and when i re-opened the sheet it was working- maybe it was like you said, a large sheet with many formulas working slowly.
thanks for the help.
Answers
-
@Brandon Morales That's interesting. Try wrapping the individual references in a value() function. So …
=value(cell1@row) - value(cell2@row)
Certified Platinum Partner
-
still wont work…
the formula is working in all the other cells though :/
-
Is this still an issue? Is any of your data coming from other sheets? Is a lot of it calculated?
Definitely possible it is due to some slowness (if it is a heavy sheet)
-
i opened up a case with smartsheet and when i re-opened the sheet it was working- maybe it was like you said, a large sheet with many formulas working slowly.
thanks for the help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!