How to mak refrence from field to another sheet field in Google Sheet?

So, I have product position I need to make to sheet of factory

CodePudding user response：

You can use IMPORTRANGE.

example:

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/[your sheet's id]/edit?usp=drivesdk","Sheet1!G2")