Formula to return a blank cell if columns are blank
Hello,
I am working on a formula that will return me the following:
 If equal to or less than 4 = Low
 If equal to or less than 7 = Modest
 If equal or less than 11 = Moderate
 If Greater than 12 = High
=IFERROR(IF([Risk Score (calculated)]@row <= 4, "Low", IF([Risk Score (calculated)]@row <= 7, "Modest", IF([Risk Score (calculated)]@row <= 11, "Moderate", IF([Risk Score (calculated)]@row >= 12, "High")))), "")
I would like it to not have a value in the Risk Severity column if the Risk Score is Blank. Currently if the cell is blank, it is showing me "Low" as the value in the Risk Severity.
Any recommendations?
Best Answers

Hi @AmyD ,
Try this:
=IFERROR(IF(ISBLANK([Risk Score (calculated)]@row), "", IF([Risk Score (calculated)]@row <= 4, "Low", IF([Risk Score (calculated)]@row <= 7, "Modest", IF([Risk Score (calculated)]@row <= 11, "Moderate", IF([Risk Score (calculated)]@row >= 12, "High", ""))))),"")
Let me know if it works for you!
Best,
Heather

@AmyD Happy to help!
Answers

Hi @AmyD ,
Try this:
=IFERROR(IF(ISBLANK([Risk Score (calculated)]@row), "", IF([Risk Score (calculated)]@row <= 4, "Low", IF([Risk Score (calculated)]@row <= 7, "Modest", IF([Risk Score (calculated)]@row <= 11, "Moderate", IF([Risk Score (calculated)]@row >= 12, "High", ""))))),"")
Let me know if it works for you!
Best,
Heather

Yes, this worked out perfectly! thanks so much!

@AmyD Happy to help!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!