Ifthenelse
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!