5x5 risk calculation
Hello there
Can anyone please tell me what I am doing wrong with this formula? it is a risk calculation. I think i am making an error with the between numbers if than makes sense. As in what but less than 7 for example.
Your help would be greatly appreciated.
=IF([Inherent Risk Factor]@row = ""; ""; IF([Inherent Risk Factor]@row = <3; "VERY LOW"; IF([Inherent Risk Factor]@row < 7; "LOW"; IF([Inherent Risk Factor]@row < 11; "MEDIUM"; IF([Inherent Risk Factor]@row <= 17; "HIGH"; IF([Inherent Risk Factor]@row < 24; "VERY HIGH"; IF([Inherent Risk Factor]@row = 25; "CATASTROPHIC")))))))
Answers
-
It think it may be as simple as replacing the semicolons ( ; ) within the formula with commas.
=IF([Inherent Risk Factor]@row = "", "", IF([Inherent Risk Factor]@row = <3, "VERY LOW", IF([Inherent Risk Factor]@row < 7, "LOW", IF([Inherent Risk Factor]@row < 11, "MEDIUM", IF([Inherent Risk Factor]@row <= 17, "HIGH", IF([Inherent Risk Factor]@row < 24, "VERY HIGH", IF([Inherent Risk Factor]@row = 25, "CATASTROPHIC")))))))
Hope this helps!
Heath Hilton
-
The error is in the first line
IF([Inherent Risk Factor]@row = <3
You would need to change it to either
<3
Or<=3
Please note that in the current formula format anything above 25 will not return anything and 24 will not return anything.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!