No one can make everyone happy - best be authentic for yourself and spend time and energy on those who deserve it.
You have said it all....you cannot make everyone happy, the moment we realize that the easier it will be for us to handle people in a better way..
Some people are "people pleasers" and spend their life miserable.
Which is very sad..