checkbox to see if there is a value in a cell on another sheet.
I have a master progress sheet for a project with a bunch of different projects. To track my own progress on another part of the project, I've created a PRODUCTION sheet, as parts of my task don't need to be included in the master sheet. one of the columns of the MASTER sheet is production coordinator that can have several different employees names in it. What I would like to do is have a checkbox column on my PRODUCTION sheet that automatically populates to see if anyone has been assigned in that production coordinator column in the MASTER sheet.
IE - MASTER sheet has rows for projects X1 - X47. Someone was assigned as production coordinator for X11 and X20. I want my PRODUCTION sheet to automatically populate the checkbox with a check in a "Downloaded" column when the production coordinators have been populated in that master sheet so I know it's has someone on it.
Help Article Resources
Check out the Formula Handbook template!