hi,
are you using metasound or soundcue ?
when your function switches gears i expect it has something like RPM >= ShiftUpRPM and then CurrentGear++ or visa versa
If you like to play a Gearbox sound you could make it a oneshot Play Sound at Location | Unreal Engine Documentation
and play it when CurrentGear changes.
hope this helps you
cheers