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.
Tags:
Answers

This looks correct to me  there is a stray space after the second IF statement before the bracket. That might help

Thanks
I did try the CONTAINS formula and it worked with the exception of Arkansas/Kansas, etc.
I switched it to a HAS formula and it worked perfectly.
Thanks
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!