Linking checkboxes across 2 sheets

Chris Farley
Chris Farley ✭✭
edited 09/23/22 in Formulas and Functions

I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered data.

I want to link a checkbox when any end of day report has a "Install complete" checked and it matches the Project name in my job folder sheet. There are multiple entries with the same project name in the end of day report and I only need the "Install Complete" checked once to return a true value for the job folder sheet.  


In the attached screen shots I'm trying to link the highlighted checkbox when the highlighted project matches. 


How can I do this? 


SS job folder.JPG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!