How to Match Regions to States in a Column


I am creating a sheet that needs to identify the "region" based on the "state" in the preceding column. I've tried multiple formulas and get back an error message (unparseable). What am I missing?

=IF([State]1=ny,nj,ct, "northeast",IF([State]1=nc,sc,ga, "southeast", IF([State]1=ca, az, nv, "west")))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!