Populating a checkbox based on the value from another worksheet
I have a checkbox column on one worksheet that I would like checked based on the data from another sheet - basically changed to "Approved". The first sheet is named Project Documentation Tracker and the second sheet is named Approved Selections. It would be based on Approved Selections Column Category = Project Documentation Tracker Subcategory, approved selections client approval = Approved, check checkbox.
I have tried an IF statement in the project documentation tracker referencing the other worksheet but keep getting an error. Thank you
Help Article Resources
Check out the Formula Handbook template!