I have been having painful (7/10) bowl movement on an off for 2 weeks now. Today I saw blood in my stool. Is this something I need to go to ER for?

Possibly. There are several potential problems you might have that warrant an investigation. I am concerned for anal fissure, thrombosed hemorrhoid, infectous colitits, or possibly inflammatory bowel disease. The evaluation can happen at an er, your family doctor, or a gastoenterologist.