I am trying to auto-populate a column based on another column's choice.
For Example, Column A (labeled Job Title) there are 4 choices. I would like to have another column (Column B) auto populate with text based on a lookup from another list.
I have tried several ways to do this and have come up empty. My current method seems to have gotten me closer than the previous ways.
I have created a column (Column B) labeled Default Job Access. That column is a calculated column and in the formula, I have
=IF([Job Title] = CSP;"TRUE";"FALSE").
If I can get this to work, then I will change TRUE and FALSE to text stating the job access. If this doesn't make sense, I apologize. I am just frustrated.