Simultaneous Artist Team Workflow live on same project

I'm not sure where to ask this question:
Where can I find more info for a TEAM workflow for Artists? For example can 3 or 4 artist work on the same project at the same time and each see the other's changes live?

1 Artist will create and export model assets from a DCC directly to the /assets/models folder
Another artist will create and assign materials
Another artist will place the assets in the scene
Another artist will setup lighting

Can all this be done simultanously? (similarly to how multiple people can edit a single google sheet at the same time)

 

I have seen experiments at this, but I can't remember their name, and haven't seen anything get far beyond the prototype stage.

Most projects work through a version control model where you have to manually download and upload changes through a (hopefully) easy to use interface.

 

Yes the problem with this is that developers are use to this kind of thing and use it all the time. Artists not so much. We're kinda hoping for a more simplified use where we all just open the project from our local server, all at the same time...