You can’t have Airtable automatically check a “Checkbox” type field for you - but you can use a “Formula” field to return either a green check emoji or a red x emoji based on the select fields.
Make a Formula field, “Ideal”, with this formula:
IF(OR({Whose Job Now?},{Whose Ideal Job?}),IF({Whose Job Now?} = {Whose Ideal Job?},"✅","❌"),BLANK())
The first part of that checks if there is a value in either {Whose Job Now?} OR in {Whose Ideal Job?} - if not (both are blank), it skips over the middle part of the formula and executes the BLANK() at the end, which just means the cell will be blank.
If there is a value in either of those fields, it will check to see if they are the same - if so, it will return :white_check_mark: in the cell, and if not, it will return :x: in the field.
You can, of course, change the emojis to whatever you’d prefer to represent “yes” and “no”. But this is the way I would do what you are looking for.
EDIT: To add that you can filter a table based on the presence of an emoji in a cell, so you could still filter this to show only :x: ’s, just as you could to show only unchecked boxes.
