Per the documentation on Startup, you don't need to have a separate .Rprofile for each project:
So, if you don't put a .Rprofile in the working directory, then it will check the home directory -- or you can set the appropriate environment variable.
That said, it's worth reading this discussion of what does and doesn't belong in the .Rprofile, if you haven't previously: