I'm trying to calculate the value in the Pipeline
Answers
-
I have a similar situation, but I'm trying to calculate the value in the Pipeline. If the forecasted value has been exceeded, I'm getting a negative number with my current formula. I need it to show zero instead of a negative.
Below is what I'm currently using. Any help would be greatly appreciated!
=IFERROR(IF(OR([START YEAR]@row = [CURRENT YEAR]#, [END YEAR]@row = [CURRENT YEAR]#), [IN YEAR $ FORECAST]@row - [CY SAVINGS REALIZED]@row, 0), "")
-
I think, for this situation, you need to wrap it in another if so that if it goes negative you just display a 0. Try this formula.
=IFERROR(IF(OR([START YEAR]@row = [CURRENT YEAR]@row, [END YEAR]@row = [CURRENT YEAR]@row), IF([IN YEAR $ FORECAST]@row - [CY SAVINGS REALIZED]@row > 0, [IN YEAR $ FORECAST]@row - [CY SAVINGS REALIZED]@row, 0)), "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!