Did you upgrade to Oreo recently? If so, it's no longer there. You'll need a 3rd party messaging app (like Google's Messenger or Textra) that still supports individual ringtones.
Plenty of threads on this subject here in the Forums, unfortunately. S9's messaging app also got rid of that, so you can 'thank' Samsung for it