I am new to SharePoint.
I am looking for a way to assign a value for a column depending on another column's value. For example, the choice column dictates "New York" the value of the calculated column would display "Person1," and there are also more choices like "Florida" and the column should write "Person2".
What is the exact formula for this?
Thanks!