Phone alert on a text message with sound overriding phone sound setting / turned off?

[AC Question]

I get alerts from work on my phone and often time have to have the phone sound off for meetings etc...but would like to have a sound alert when I get a alerts from work. So wondering if there is a way for it to over ride the phone sound setting when a text is received from a specific number.