subtraction formula
Hello! I’m trying to use a simple subtraction formula =[# of Transactions]@row - [Total Rejected]@row to populate a total processed column however if total rejected isnt populated then it automatically places the number of transactions into to total processed….i’ve tried multiple things with no luck. Any help you can provide is greatly appreciated!
Best Answer
-
Hi @Mailynm
Would this work for you?
=IF([Total Rejected]@row<>"", [# of Transactions]@row - [Total Rejected]@row)
The IF first checks that the [Total Rejected] is not blank. If there is something in the [Total Rejected] cell, the subtraction happens. Otherwise the [total processed] cell remains blank. If you wish for a different outcome rather than keeping the [total processed] blank, we can build that. Let me know.
cheers
Kelly
Answers
-
Hi @Mailynm
Would this work for you?
=IF([Total Rejected]@row<>"", [# of Transactions]@row - [Total Rejected]@row)
The IF first checks that the [Total Rejected] is not blank. If there is something in the [Total Rejected] cell, the subtraction happens. Otherwise the [total processed] cell remains blank. If you wish for a different outcome rather than keeping the [total processed] blank, we can build that. Let me know.
cheers
Kelly
-
@Kelly Moore This worked perfectly and did exactly what I needed it to do! Thanks for your help!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!