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
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!