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
- 10.8K Get Help
- 65 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.6K Ideas & Feature Requests
- 56 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives