Help converting a simple IF formula to a column formula

capenancy

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

David Tutwiler

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

David Tutwiler

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

capenancy

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

David Tutwiler

No problem. Glad you got it going.