Is there a way to click on a cell in one report and have it take me to another report?

Tara_400_Rosmar

I have one report which summarizes all items "drafting for fabrication" I would like to be able to click on a person assigned to this so that I can see what their whole job load looks like. Each person has a report but if I want to move around the priorities this would be helpful.

Leibel S

@Tara_400_Rosmar

This would depend on how you are creating each of these sheets...

You could technically have a central sheet with a list of each person and next to it a link (not as a hyperlink just as plain text).

Then your sheets would look up the central sheet to get the person's report...

SolutionSal

Hi Tara,

This type of feature isn't currently available as described. You could implement something similar by adding a column which contains the link to the relevant report. This would allow users to easily click the link and navigate to relevant report. This link could be auto populated by a column formula using INDEX/MATCH. This would require you to setup a reference table with all possible Assigned To values in one column and the link to their report in another column. The Assigned To would be used as a lookup key for populating link. This update would have to be applied to underlying source sheets to then be included in report shown in your screenshot. Here are some relevant help articles.

• Formula combinations for cross sheet references
• Advanced Cross-sheet Formulas
• Create cross sheet references to work with data in another sheet
• Use column formulas to apply calculations to all rows in a sheet

Hope this helps!

Sal

Tara_400_Rosmar

Thank you. I think I understand... I'm going to try this now. If I can't get it can we chat?