Cross Sheet referencing



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





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!