Can we show Sheet Summary data on sheet itself to avoid inputting data twice?

beatea

Project Sheet 1 and Project Sheet 2 have detailed data.

Sheet_report_summary pulls the "Sheet Summary" data (icon in the right pane) for executive summary.

In our engineering meetings, we drill down into the details of each sheet. 

Can I show the "sheet summary" data on the sheet itself? For example, a project is RED- Delayed. This is clear on the Sheet_report_summary but I'd also like to easily show it on the sheet automatically so user does not have to update in multple places.

 

 

Andrée Starå

Hi,

Yes, you can link from the Sheet Summary to other cells in the same sheet.

Would that work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD