Nested IF Formulas

I am trying to populate a cell based on the State that they had choice from a dropdown column on the same sheet/row. I am tried many variations of the below formula and it is not working.

Does anyone have any suggestions.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!