You haven't said what went wrong or which compiler you are using, so its hard to say how to fix it.
First thing to check: you need to define SFML_STATIC in your project (or at least make sure its defined before including any sfml headers).
Next, at least on Visual Studio, you need to link with every dependency. For example sfml-graphics-s.lib requires you to link with opengl32.lib and freetype.lib too. Dynamic linking doesn't need that, the dlls include their dependencies already, but static linking works differently and needs then explicitly.
You can find a list of which libraries you need here:
https://www.sfml-dev.org/tutorials/2.6/start-vc.phpI don't know about other platforms, I don't use SFML on them.
The way static and dynamic linking works on Windows (.lib and .dll files):
Static linking - a .lib file (static library) contains precompiled but unlinked code, basically an archive of .obj files. When you link with the .lib, the linker will add any required parts to the final .exe file. It doesn't add parts that aren't used by the .exe. You can now distribute the .exe on its own.
Dynamic linking - a .dll contains fully compiled and linked code. There is also a tiny .lib (import library) that contains just a list of what's exported by the dll. When you link with the .lib, code is added to the .exe to find and load the .dll at runtime and call the code in it. You distribute the .exe and the .dlls, not the .lib
A static link will actually give you a smaller distributed size, because only the parts of the libraries that are used will be added to the final .exe. A dynamic link will give a smaller .exe size, but the .dlls need to be there too and they contain everything, even if its never needed, so the total size is bigger.
Although if the .dlls are already on the user's system in a suitable location (there's certain locations that are checked), you don't need to distribute them. But then if the user doesn't have them, the program will crash.
(There's other stuff, this is just the basics)