Help converting a simple IF formula to a column formula
Can someone advise what is wrong in the syntax that is causing it to not be converted to a column formula?
=IF([Inherent Risk Level]1 = "Low Risk / Minor", "1", IF([Inherent Risk Level]1 = "Moderate Risk / Material", "2", IF([Inherent Risk Level]1 = "High Risk / Critical", "3")))
Thank you
Best Answer

Have you tried changing the [Inherent Risk Level]1 to [Inherent Risk Level]@row? I think that's required for Column formulas.
Answers

Have you tried changing the [Inherent Risk Level]1 to [Inherent Risk Level]@row? I think that's required for Column formulas.

That works! I couldn't figure out the reason for using @row but it works!!! Thank you so much :)

No problem. Glad you got it going.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!