Sort and filter function in sheet with locked column(s)

[KSEC1713]

Good day, everyone,
Hoping someone can help solve an issue I'm running into. I'm trying to find out if there is a way to lock a column in a data set, protect the sheet so no one is able to edit values in that column only, and still have the ability to sort and filter the worksheet. Is that possible? I've tried all sorts of combinations of locked and unlocked cells, "Allow Edit Ranges", etc. but have not discovered a way users can filter and reorder the data while that column is locked and the sheet protected.

 

[Fluff]

You can use the autofilter on a locked sheet, but you cannot use the sort.