I needed help in figuring out a formula.
I have 2 dropdown columns. One of them contains options for Required Skills for the job role. The second contains identical options for Actual Skills for the job role. The manager would select the Required Skills and the Actual Skills the employee has.
I want a formula column to show the gaps, meaning the options that are in the Required Skills but are not in the Actual Skills.
I’ve tried many different things, but can’t seem to figure it out.
Thank you in advance!