Hi ebackwardse1, and welcome to the forum.
I hear you on the data validation not working in the webapp. It's a big miss in my opinion. Having said that, we can put together a workaround using PivotTables which I described in this blog post
Do you think this might work for you?