Nesting Formulas
Hello Smartsheet Community,
I have a formula in Smartsheet that works:
=IF(ISERROR(MATCH(5, [Risk Rating]3:[Risk Rating]19, 0)),IF(ISERROR(MATCH("HIGH RISK", HIGH23:HIGH25, 0)), IF(MEDIUM26 > 935, IF(ISERROR(MATCH(5, [Risk Rating]17, 0)), "HIGH RISK", "VERY HIGH RISK"), IF(MEDIUM26 > 310, "MEDIUM RISK", "LOW RISK")),IF(ISERROR(MATCH(5, [Risk Rating]17, 0)), "HIGH RISK", "VERY HIGH RISK")), IF(ISERROR(MATCH(5, [Risk Rating]17, 0)), "HIGH RISK", "VERY HIGH RISK"))
And I want to add an IF statement that IF MEDIUM26 is 0 result is NOT DONE.
I thought removing "LOW RISK" from IF(MEDIUM26 > 310, "MEDIUM RISK", "LOW RISK")), making it IF(MEDIUM26 > 310, "MEDIUM RISK"), and then adding IF(MEDIUM26 > 1,"LOW RISK", "NOT DONE") would do it, but new to this and have been struggling with getting it to work.
All I want to do is report "NOT DONE" if cell MEDIUM26 is 0.
Then my result would be either VERY HIGH RISK, HIGH RISK, MEDIUM RISK, LOW RISK or NOT DONE.
Any assistance would be appreciated.
Terry
Comments
-
Change the entire bold portion of your formula to this:
IF(Medium26 = 0, "Not Done", IF(Medium26 > 310, "Medium Risk", "Low Risk"))
-
Thanks Jessica. That worked.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives