I have two lists in SharePoint 2013
Drivers has a column called Active Driver that is a single line of text formatted "Lastname, Firstname". Drivers also has a separate column that is a Person column which I am not using for the lookup (since I only want to show active drivers based on other logic - irrelevant here).
Trips has a lookup column that looks up the "Active Driver" column.
Trips has a View which I want to filter by Active Driver is equal to
[Me]. But it's not working. It's as though I need something like
Text([Me]) but that is not working either.