I and I think alot of others really need this,
We need to be able to have a global reference point so that we can reference across multiple sheets that have that same column .
at the moment we can only refence one sheet at a time per formula
example:
=INDEX({MACH MAT}, MATCH([Row ID]@row, {MACHROWID}, 0))
If i want to find the same thing in another sheet i need to edit the forumal to then reference the other sheet
=INDEX({CREEK MAT}, MATCH([Row ID]@row, {CREEKROWID}, 0))
This becomes a major problem if I am trying to create a master sheet and update values for that sheet or other sheets cause I requires redoing the formula every time and rows nor matching if there is a change on the base sheet that i copied the row from to the master sheet.
what I would like is being able to have a global refernce value that I can apply to any multiple sheets and therefore be able to find values through multiple sheets.
example:
Global refernce applied to each sheet:
Sheet 1 Column A = {GLOBAL MAT} , Sheet 1 Column D = {GLOBALROWID}
Sheet 2 Column B = {GLOBAL MAT} , Sheet 2 Column F = {GLOBALROWID}
Sheet 3 Column C = {GLOBAL MAT}, Sheet 3 Column G = {GLOBALROWID}
Formula On main Sheet Looking for info across all sheets:
=INDEX({GLOBAL MAT}, MATCH([Row ID]@row, {GLOBALROWID}, 0)
and this would find the corresponding information from any of those sheets with the reference {GLOBAL MAT} and {GLOBALROWID}
I believed this has been asked for alot and would greatly improve usability of smartsheets, especially for user like me from Australia and European servers because alot of third party apps like Zapier don't work with our smart sheets
