Is there a formula that would check a box if a certain column in a sheet is repeated in another?

Options

Hello! I am trying to create a cross-referencing set-up in my sheet. I will be generic in my explanation:

I have two sheets - one with a tracking sheet that tracks submissions, where the left column is a checkbox. The other sheet is where I get updates on submissions as they come in. I update the submissions on an Excel sheet, which is transferred to the update sheet through Data Shuttle.

I am trying to have the box check itself if the submission sheet 'name' is on the tracking sheet, i.e. if the form is submitted and the name pops up on my submission sheet, then the box will check itself on the tracking sheet.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!