Columns do not line up if hidden if referencing 'in' from another sheet

Seth Morth

Hello!

I am referencing a single row of pertinent information into "Sheet #A, Master" from multiple other sheets "Content Sheet #b"; "Content Sheet #c"; "Content Sheet #d"; and so on.

That works, but when I first build the link ALL of the columns in "Sheet #A, Master" need to be unhidden first.

This is definitely a rich person problem, but it is super annoying, especially if I forget and then have to redo the links. Am I missing some simple step in referencing in from another sheet so the data goes into it's proper, but hidden column rather than putting data only into visible columns in the "Sheet #A, Master" sheet?

Many thanks!

Step1.jpg

Step2.jpg

See attached. Row 7 was added with all Columns unhidden, Row 8 was added with a few columns hidden, and the data got shifted. Step1 shows the 'good row 7' with those columns hidden AFTER the Row7 data was added. Row8 was then added, and the data is shifted as shown in Step2 with all columns unhidden.

Thoughts?

Andrée Starå

@Seth Morth

Happy to help!

Ah, now I follow.

Yes, that can be cumbersome. It would be great if we had different presets/views that we could save.

Please submit an Enhancement Request when you have a moment.

Andrée Starå

Hi @Seth Morth

I hope you're well and safe!

Have you looked at using cross-sheet formulas instead?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Seth Morth

Thank you for your comment Andrée,

I was trying to keep it simple by referencing an entire row (as a range) with one click, rather than building in each reference. Speed and efficiency outweighs accuracy; I simply do not have the time to build individual cel references for dozens of sheets, and each sheet is named differently.

See attached Range.jog

Range.jpg

Andrée Starå

@Seth Morth

Happy to help!

If you select the option Link from cell in other sheet in the right-click menu instead you should see everything unhidden if I'm not mistaken.

Did that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Seth Morth

Thank you for the deeper assist Andrée,

At that stage it shows all cels unhidden in the source sheet, but that is not my issue. The problem is in the sheet I am linking into. If the sheet I am linking into (we can call it an overview sheet) has columns hidden that data is offset when I bring in the linked source row (even if all the source columns are unhidden, and even though all the source columns are shown as part of the linking process). It is offset by the hidden columns in the overview sheet, and if the link is established and then all the columns are unhidden in the overview sheet there are columns without values in the overview sheet.

Andrée Starå

@Seth Morth

Happy to help!

Ah, now I follow.

Yes, that can be cumbersome. It would be great if we had different presets/views that we could save.

Please submit an Enhancement Request when you have a moment.

Seth Morth

Done! Thanks for validating my experience.

Andrée Starå

@Seth Morth

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!