If-then-else
trying to get a formula for a risk register. Tried the below but cant get it to work
=IF({Risk Rating}@row<= 6,= "No significant impact")
or
=IF(Risk Rating @row<= 6, "No significant impact")
once I get this right, I can add the other ifs.
Answers
-
Try this. Replace your curly bracket with a square brace as so:
=IF([Risk Rating]@row <=6, "No significant impact")
If your column header has a space in it, the square braces make the formula view the title as a string and doesn't break them at the space.
If your column header is a single word with no spaces in it, then you would not need the square braces in the formula. E.g., =IF(Risk@row <=6, "No significant impact")
-
Thank you so much, that worked. Now, to bug you further, I have further criteria to determine higher levels of risk, what would I use? I am having trouble with the "or" as I need to determine between a range.
=IF([Risk Rating]@row <= 6, "Very Low - Acceptable Risk"),([Risk Rating]@row >= 7,OR, <=10,"Low - Acceptable Risk"), ,([Risk Rating]@row >= 11,OR, <=15, "Medium - Possibly Unacceptable Risk"),([Risk Rating]@row >= 16,OR, <=23, "High - Unacceptable Risk"),([Risk Rating]@row >= 24,OR, <=30,"Very High - Unacceptable Risk")
Any help greatly appreciated. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!