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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!