Jump from one Smartsheet row to a specific row in another smartsheet
I use 2 smartsheets. I call them SS-Overview and SS-Detail for better understanding.
SS-Overview contains over 1000 rows, SS-Detail with many more columns currently only about 70 rows.
I want to be able to jump back and forth between the sheets linked by name.
In a column of SS-Detail is e.g. the name - this is also in a column in the Smartsheet SS-Overview. The name can only be adjusted in SS-Overview, in SS-Detail it will be adjusted automatically. This works very well so far.
My challenge now is that I have to constantly switch between the sheets. For example, if I am standing on a row in SS-Detail, I would like to be able to go into SS-Overview with one click and automatically stand on the record that it is linked to. This eliminates the need to constantly search for the equivalent record, since the smartsheet is not always sorted by name. After all, if I click on the link in SS-Detail, it just opens the window to re-link the field, which is not what I want.
I hope that my challenge is understood.
Thanks and greetings