Cross Sheet referencing

Hello,

I have a master sheet, where I am keeping track of the progress of various tasks. The progress is being monitored using checkboxes.

The structure of the sheet will be clearer through IMAGE A. Each project has it's own smartsheet and I would like to format the master sheet based on targets met in the individual sheet.

For example: If the task A for project A is 100% (as shown in the individual project sheet), then the checkbox in the Master sheet should be ticked.

Is it possible to do this kind off formatting ? As far as I know cell linking is one way of connecting master sheet to individual sheets.

Thank you

IMAGE A.PNG

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi,

You could use cross-sheet formulas or you could connect the individual sheets thru cell-linking to the master sheet and then have formulas looking at those cells and check the boxes if they are 100%.

After you've set up the cell-links, you could hide the columns.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

I would suggest cross sheet references in formulas. You would need to be careful though in how you set up your cross sheet references because you could end up hitting the limit relatively quickly depending on the number of projects.

Sign in to join the conversation!

Quick Links

Trending discussions

Calculating Quarters with a Start and a Finish date
I searched the community and did not see a formula that calculated Quarter based on a Start and a Finish date while also accounting for cases where the year for the Start and Finish date differ. The formula below handles that. A few notes … It assumes that Finish is always >= Start. The entire formula is wrapped with…
Circular Reference with formula
i am not good with writing formulas within a sheet. I asked the AI tool in the sheet to help me write a formula and I am getting a Circular reference back. I'm trying to have it write the following formula for me. If the column "Tracking #" is not blank, change Column "Deployment Phase" to "Shipped" I have tried adding in…
How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…