Settings - Sounds and vibration - Notification sound
Some apps, may have their custom notification sound setting overriding the system sound. For those apps, you can go into that particular app setting and they will have an option to choose the notification sound you want.