How do I make the numeric value returned in this formula usable in other mathematical formulas?
Value returns correctly, but I need to be able to add that value to OTHER formulas and fields.
=IF([Target Level:]@row = "Standard", "$19,000", IF([Target Level:]@row = "Superior", "$100,000", IF([Target Level:]@row = "Premier", "$240,000", IF([Target Level:]@row = "Elite", "$490,000", IF([Target Level:]@row = "Platinum", "$875,000", IF([Target Level:]@row = "Presidential", "$1,500,000"))))))
TIA!
Answers
-
1) By using "$240,000" in the formula Smartsheet sees it as text.. it sees it as no different than "Hot Chocolate". So you want to type 240000 and let the formatting of the column change it to $240,000
2) Try this:
=IF([Target Level:]@row = "Standard", 19000, IF([Target Level:]@row = "Superior", 100000, IF([Target Level:]@row = "Premier", 240000, IF([Target Level:]@row = "Elite", 490000, IF([Target Level:]@row = "Platinum", 875000, IF([Target Level:]@row = "Presidential", 1500000))))))
Brent C. Wilson, P.Eng, PMP, Prince2
Facilityy Professional Services Inc.
http://www.facilityy.com
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!