Calculate the cost after percentage discount if percentage discount is populated
Hello all,
I have 3 columns in my Smartsheet List Price, Percentage Discount and Net Price. If the List Price and Percentage Discount are populated for a row, I'd the Smartsheet to determine the Net Price based off List Price and Percentage Discount. Some will not include a percentage, so I can't use =([List Price]1) - ([List Price]1) * [Percentage Discount]1. I need somekind of =IF(NOT(ISBLANK( formula.
Thanks in advance! This community is a LIFESAVER!
Answers
-
I think I got it :)
=IF(NOT(ISBLANK([Percentage Discount]1)), ([List Price]1 - ([List Price]1 * [Percentage Discount]1)))
SO far it seems to be working, but it anyone spots an error, please let me know.
Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives