Help converting a simple IF formula to a column formula
Options
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!