When I activate/open a sheet (SH16) using a button I would like a filter to be applied. In this case, the field name is [Strategic Priority Only] and the field value is "Yes". That is the only option for a field value.
I tried using the Action of Selection > Select in Field but it is not working.
Did you assign that action to the OnActivate sheet trigger? If you want to select only the value "Yes" then the search string would be Yes without the quotes.
.png "Luminary Alumni"){kind=icon}