You need to change the notification sound in the app settings and not in your phone general settings. In the message app tap on the three dots top right - settings - scroll down - sound. In the Gmail app open the side menu - settings - select account - manage labels - select sound for any of the different labels.